Syntax? Select * From table Where.. Then Join?

If that makes any sense.....
I'm trying to figure out Joins, and I found some great links in another post, but I'm trying to do something pretty complex. After searching and searching, I think I need to just ask. I'm using ASP to connect to a dBase3 database to pull product info.
Can I do something like:

"SELECT * FROM categoryxproducts WHERE cat_id = " & MatchCatID & " INNER JOIN products ON categoryxproducts.product_id=products.id"

& MatchCatID & is the category's id pulled from the category table.

It's not working, so I wasn't sure if I could even use the
WHERE cat_id = " & MatchCatID & "
with an Inner Join.

What I need is to get all products from products.dbf that have the selected category ID from categoryxproducts. Am I just lopping up the syntax, or is there another way I should be doing this??

I tried moving around my syntax a bit, incorporated all three tables I needed, and got this to work.

"SELECT * FROM categories, categoryxproducts, products WHERE categories.code='" & SelCatCode & "' AND categories.id=categoryxproducts.cat_id AND categoryxproducts.product_id=products.id"