mysql select * from one table and select some from joined 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...