mysql get all columns from table and one column from joining table code example
Example: sql select all from one table and one column from another
SELECT myTable.*, otherTable.foo, otherTable.bar...
SELECT myTable.*, otherTable.foo, otherTable.bar...