How to join two tables

[Bill]

I have a table of books, with titles, isbns and a many to many table,
which has categorys and isbns (some books are in more than one
category).

I want to pull up all the titles where their isbn is equal to the isbn
where the categoryid=a_nu mber

How would I write this?

Thanks,

Bill

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!