JOINS

Question 1

INNER JOIN

Answer 1

• Retrieves records that have matching values in both tables
• EXCLUDES records taht dont have a match in either table

Question 1

LEFT JOIN

Answer 1

• Retrieves ALL records from the left tables and matches them with corresponding records from the right table
• It includes NULL values for non-matching records from the right table and only includes records that match from the right table

Question 2

RIGHT JOIN

Answer 2

• Retrieves all records from the right table and matches them with corresponding records from the left table
• It includes NULL values for non-matching records from the left table and only includes records that match from the left table

Question 3

FULL OUTER JOIN

Answer 3

• Retrieves all records from BOTH left and right tables
• Includes records that have MATCHING values in EITHER table, as well as records that DO NOT have a match in either table, filling in NULL values accordingly