-
Showing Rows a Table that are not in another table
Hi, I have two tables : Book and Person both have ID columns.
There is another table BookToPerson with PersonID and BookID foriegn keys.
I need to show Rows from Book table that are not assigned to the Person. That is, if the BookId is not present for PersonID in BookToPerson, I must show that Book's details on my form.
I have been trying to work around a query, but I am not that proficient in SQL yet. So I need help...
-
Something like:
select * from book where bookid not in (select bookid from booktoperson)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|