MySQL JOINs | Dataford Interview Questions

Tell me about the four 'join's in MySQL.

Use the provided left_records and right_records tables to demonstrate the result of each join type. Include matched rows, unmatched rows from both sides, and a small Cartesian-product example.

Output

Columns: join_type, left_record_id, left_label, right_record_id, right_label
Include results for INNER, LEFT, RIGHT, and CROSS joins
For CROSS join results, use left record IDs 1 and 2 with right record IDs 101 and 102
Order by join type in the order INNER, LEFT, RIGHT, CROSS, then by record IDs with NULLs last

Schema

left_records

Column	Type	Description
record_idPK	INTEGER	Unique identifier for a left-side record
join_key	INTEGER	Value used to match records between tables
label	VARCHAR(50)	Descriptive label for the left-side record

right_records

Column	Type	Description
record_idPK	INTEGER	Unique identifier for a right-side record
join_key	INTEGER	Value used to match records between tables
label	VARCHAR(50)	Descriptive label for the right-side record

Your question is MySQL JOINs. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem