mindwarpltd
asked on
Need to select for missing referencial integrity
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.