Anti-Join Without EXCEPT | Dataford Interview Questions

Given two tables, write a query to identify records that exist in one but not the other without using EXCEPT.

For this exercise, compare source_records with target_records using record_id. Return records present in source_records that have no matching record in target_records.

Output

One row per unmatched source record.
Return record_id and record_name.
Sort by record_id in ascending order.

Schema

source_records

Column	Type	Description
record_idPK	INT	Unique identifier for the source record
record_name	VARCHAR(100)	Descriptive name of the source record
record_status	VARCHAR(20)	Current status of the source record

target_records

Column	Type	Description
record_idPK	INT	Unique identifier for the target record
record_name	VARCHAR(100)	Descriptive name of the target record
record_status	VARCHAR(20)	Current status of the target record

Your question is Anti-Join Without EXCEPT. 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