SQL: How to SELECT tablename.*

Question

Hi,

I tried doing this but it failed.

SELECT table2.ID, table1.* FROM table2
LEFT JOIN table1 ON table1.ID = table2.table1ID

How do you select all columns from a table?

EDIT: There is no error in the above query. I don't know what caused the error but the code is now working.

Answer 1

What was the error message? Are you running on SQL Server?

Answer 2

You had field names conflict as both tables have ID field. You must to

 SELECT table2.ID as t2_id, table1.* FROM table2
LEFT JOIN table1 ON table1.ID = table2.table1ID

Answer 3

    SELECT t2.ID, t1.* FROM table2 t2
LEFT JOIN table1 t1 ON t1.ID = t2.table1ID

this works on sql 2000+

Answer 4

What you have is syntactically correct, exactly what did you mean by it failed? Did you get an error message or just not the results you wanted? (BTW it is a bad practice to select *, only return the columns you need. In this case you do not need all the columns as the id field in table1 will have the exact same data as the file din table 2 it is joined to)

Answer 5

Sorry everyone, now that I run it again there is no error.
I'm not sure why I got an error last night, I thought it was because of "table1.*"

HLGEM is right there is no error with the query.