I have two tables that are related through a primary key.

The tables are:

catagories
catId (PK)
catName

details
catId
make
model
etc...

The "catId" field is the primary key for the "catagories" table, and there is no primary key for the "details" table.

This is the first time I have tried to select information from multiple tables at once.

What I need to know, is if it is possible (and I believe it is) to select the "catName" from the "catagories" table and all the fields from the "details" table in one query. If so, how would you write the query?

And how would you extract the information from the result set?

Thanks!