MySQL Select all columns from one table and some from another table

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 foo and bar from otherTable.

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

Add a Comment