Showing Rows a Table that are not in another table

[MoneyRan]

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...

[rmiao]

Something like:

select * from book where bookid not in (select bookid from booktoperson)