join two tables in mysql
October 1st, 2008 by Lawrence David
to output the rows from two tables, indexed according to a column shared in common by the tables:
SELECT table1.col1, table2.col2, FROM table1 LEFT JOIN table2 ON table1.col3 = table2.col3
