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: Return all rows from the left table, and the matched rows fro...