When you execute a query using the RIGHT JOIN syntax, SQL does two things: It returns all of the records from both tables that contain matching values, as defined by the ON clause.

Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro! Do you ever find yourself juggling queries to get the information you need ...