[RESOLVED] Select * in a join

[wmcelwee]

Is it possible to use a * when using a join or do I have to type out all my columns like table_name.column_name1... for all columns?

[Kudose]

You can use the asterisk.

SELECT t1.*, t2.colName FROM table1 AS t1, table2 AS t2 ...

[NogDog]

It is generally better to type out all the column names anyway for clarity, consistency, and error-checking (in case the table structure changes), and if you do not actually need every column in the table(s) being queried it reduces the amount of data to be exchanged between your application and the DBMS.

Anyway, if you do want all columns from a given table, you can use table_name. in the column list (or table_alias.).

[wmcelwee]

hmm... i had typed in the * but it wasn't working... maybe I had a typo in there somewhere else...

Thanks for the quick help.