Select all columns from the joined table and some from the other
This would select all the columns from the myTable.
SELECT myTable.*, otherTable.foo, otherTable.bar...Got it from here
This would select all the columns from the myTable.
SELECT myTable.*, otherTable.foo, otherTable.bar...Got it from here