SQL query for available books

[DonyBoy]

I have 2 tables for a library.
Table1: has the book details with the book-number being the primary key

Table2: has the details of borrowed books. This table also has the column book-number- linked to Table1, using the same column.

I need to make an SQL query that gives the list of AVAILABLE books (IN OTHER WORDS, REMOVING THE BORROWED BOOKS). How do I do this?

 

[PHV]

Simply follow the unmatched query wizard.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[DonyBoy]

Please explain

 

[PHV]

You don't know how to follow a query wizard ?

Anyway, a starting point (SQL code):
SELECT Table1.*
FROM Table1 LEFT JOIN Table2 ON Table1.[book-number] = Table2.[book-number]
WHERE Table2.[book-number] Is Null

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886