Search code examples
phpmysqlleft-join

select left join except one column

i have select:

SELECT t1.*, t2.* from t1 left join t2 on t2.id = t1.id

when id exist or not exist in t2 I want all columns from t2 except t2.id (which can be NULL).

Is there any way do this without print out all columns names in query?

thx

Solution

  • No, you have to either specify all columns of interest or use a wildcard.