SELECTing from multiple tables
I have two tables that are related through a primary key.
The tables are:
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?