Sometimes you want to select all the columns, without using the *. Specifying column names speeds up your query. The problem comes in with large tables or tables with difficult column names.
Solution:
Type SELECTClick the + next to the desired table in the Object ExplorerDrag the Columns folder to the query paneComplete your query by including the FROM, the table name and conditions
This gives you a nicely comma-separated list of column names.