http://www.w3schools.com/sql/sql_join.asp Scroll down to: W3 Schools said: Different SQL JOINs Before we continue with examples, we will list the types of the different SQL JOINs you can use: INNER JOIN: Returns all rows when there is at least one match in BOTH tables LEFT JOIN: ...