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

Question

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

Answer 1

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.

Answer 2

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)