Let's say I have
Table A, which has one column
id, which is unique within the table. I have multiple other tables:
Table C, ...,
Table N. Each of these tables has a column
A_id, which is a foreign key to
Is there an elegant way to get all rows of
Table A which are not mapped to as a foreign key by any of the other tables? Ideally, I would like to see if there's a way to do this without having to type in a complicated query that involves manually querying each other dependent table, but any approach would be appreciated.