How would you access all the records in A but not in B without using JOIN, WHERE, EXCEPT, or subqueries?
Assume both tables use record_id as the comparison key. Return the records whose key exists in a and does not exist in b.
record_id and record_valuea and absent from brecord_id ascending| Column | Type | Description |
|---|---|---|
| record_idPK | INT | Unique identifier for the record |
| record_value | VARCHAR(100) | Descriptive value associated with the record |
| Column | Type | Description |
|---|---|---|
| record_idPK | INT | Unique identifier for the record |
| record_value | VARCHAR(100) | Descriptive value associated with the record |