Note on Column Ordering

An important point to keep in mind is that the order of the SQL view columns must be the same in the SQL as in the list of SQL view columns. For example, if your SQL select statement is select first_name, last_name, favorite_color..., then the list of columns should be in the same order, i.e. first_name is defined first, followed by last_name, and then favorite_color.

See Also

SQL Views

Note for Oracle Database Users

Next

Note for Oracle Database Users

Note on Column Ordering