This article is tagged with:
Sql select all from one table and one column from another
and mysql
sql select all from one table and one column from another
SELECT myTable.*, otherTable.foo, otherTable.bar...