SQL Records Missing From Table | Dataford Interview Questions

Write a SQL query to find records that appear in one table but not another.

Use source_records as the table containing the complete expected record set and comparison_records as the table to check. Return records present in source_records that have no matching record_id in comparison_records.

Output

Return one row per missing record.
Include the column record_id.
Sort results by record_id in ascending order.

Schema

source_records

Column	Type	Description
record_idPK	INT	Unique identifier expected in the source dataset
record_name	VARCHAR(100)	Descriptive name of the record
record_status	VARCHAR(30)	Optional status assigned to the source record

comparison_records

Column	Type	Description
record_idPK	INT	Unique identifier found in the comparison dataset
record_name	VARCHAR(100)	Descriptive name of the comparison record
record_status	VARCHAR(30)	Optional status assigned to the comparison record

Your question is SQL Records Missing From Table. 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