The Question :
287 people think this question is useful
How do you select all the columns from one table and just some columns from another table using JOIN? In MySQL.
The Question Comments :
The Answer 1
494 people think this answer is useful
Just use the table name:
SELECT myTable.*, otherTable.foo, otherTable.bar...
That would select all columns from
myTable and columns
The Answer 2
41 people think this answer is useful
I need more information really but it will be along the lines of..
SELECT table1.*, table2.col1, table2.col3 FROM table1 JOIN table2 USING(id)
The Answer 3
12 people think this answer is useful
select a.* , b.Aa , b.Ab, b.Ac
from table1 a
left join table2 b on a.id=b.id
this should select all columns from table 1 and only the listed columns from table 2 joined by id.
The Answer 4
3 people think this answer is useful
Using alias for referencing the tables to get the columns from different tables after joining them.
Select tb1.*, tb2.col1, tb2.col2 from table1 tb1 JOIN table2 tb2 on tb1.Id = tb2.Id