SQL query help - finding rows with no relationships
- by DD
Consider a DB with a Client table and a Book table:
Client: person_id
Book: book_id
Client_Books: person_id,book_id
How would you find all the Person ids which have no books?
(without doing an outer join and looking for nulls)