This article is tagged with:
Use left outer join in sql
and mysql
use left outer join in sql
left join or left outer join
sql left join
SELECT table1.column1, table2.column2...
FROM table1
LEFT JOIN table2
ON table1.common_field = table2.common_field;