There is a list of SQL operations across multiple tables; write the final SQL to select records from table 1 that do not have a record in table 2.
Use the provided schemas and match records by record_id and table_1_id.
table_1 record.record_id, record_name, and source_system.record_id in ascending order.| Column | Type | Description |
|---|---|---|
| record_idPK | INT | Unique identifier for a table_1 record |
| record_name | VARCHAR(100) | Display name of the record |
| source_system | VARCHAR(50) | System that supplied the record |
| Column | Type | Description |
|---|---|---|
| table_2_idPK | INT | Unique identifier for a table_2 record |
| table_1_id | INT | Referenced record_id from table_1 |
| note | VARCHAR(200) | Optional note associated with the table_2 record |