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