Specific column names may be specified following the SELECT, thus designating that only those columns are to be returned. This is the way that host-language programs should be coded so that the TABLE may have extra columns added in the future and the program will not need to be modified. The column names may be stated in any order based on how you wish them to be displayed. When a table is defined, the names must be unique within each table, but the same name can be used in other tables. See Qualifying Column Names.

SELECT column1, column2, ...
  FROM table1 , table2, ...;

Note: There is a comma (,) between multiple column names and multiple table names, but there is not a comma after the last column name or table name.