I have two MS access tables in my asp.net application (named `categories` & `books`) . The first table (`Categories`) has two fields named `Category_ID` and `Category_Name`. 

The second table has three fields named `Book_ID`, `Category_ID` and `Bookname` (category\_id is joint field in two tables. In some Pages I have the `category_name` and I want to get book rows with that `category` name. In other words I should first get the `category id` based on `category name` that i have then select from books where the categoryID matchs. But I don't know how.

thank you