Notes On JOIN - MySQL
- If your INNER join is returning too few values and duplicates, you're probably using the wrong kind of join. Try a LEFT join.
- INNER JOIN is the same as JOIN
- http://i.stack.imgur.com/GbJ7N.png (diagram explaining joins)
- LEFT JOIN is used - this will return ALL rows from Table1, regardless of whether or not there is a matching row in Table2.