Need to select for missing referencial integrity
Posted on 2010-09-14
I've noticed some records where I have zero for the id of a foreign key.
I'd like a query which will tell me which records don't reference my main table.
My main table is called Pads, the primary key is PadID, the field with zero entries is AuthorID
My Other table is Authors and the primary key is AuthorID.
So I want a list of Author Records where the AuthorID doesn't appear in the pads table.