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

joinmysqlselect

How do you select all the columns from one table and just some columns from another table using JOIN? In MySQL.

Best Solution

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.