Given two tables, write a query to return records present in one but not the other using different join types.
Return only records whose record_id exists in exactly one table. Show the identifier, each table's record name when available, and which table contains the record.
records_a or records_b.record_id, a_record_name, b_record_name, and present_in.record_id ascending, then present_in ascending.| Column | Type | Description |
|---|---|---|
| record_idPK | INT | Unique record identifier in records_a |
| record_name | VARCHAR(100) | Optional name associated with the record |
| Column | Type | Description |
|---|---|---|
| record_idPK | INT | Unique record identifier in records_b |
| record_name | VARCHAR(100) | Optional name associated with the record |