The columns in the result table are ordered as they are written in the SELECT statement, irrespective of the ordering in the source table. For example:SELECT format, format_id FROM formats;
A shorthand form for selecting all columns from a table is:SELECT * FROM table ...
In this case, the columns in the result table are ordered as they are defined in the source table.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40