How would you write a SQL query to find records with no active related entries?
Use the records and related_entries tables. A related entry should exclude its record only when it is explicitly marked active.
record_id and record_name.record_id ascending.| Column | Type | Description |
|---|---|---|
| idPK | INT | Unique record identifier |
| record_name | VARCHAR(100) | Display name of the record |
| Column | Type | Description |
|---|---|---|
| idPK | INT | Unique related-entry identifier |
| record_id | INT | Referenced record identifier |
| entry_type | VARCHAR(50) | Type of related entry |
| is_active | BOOLEAN | Whether the related entry is explicitly active |