Returns all rows when there is at least one match in BOTH tables
Return all rows from the left table, and the matched rows from the right table
Return all rows from the right table, and the matched rows from the left table
Return all rows when there is a match in ONE of the tables