Results 1 to 8 of 8
Thread: SELECTing from multiple tables
Aug 28, 2002, 12:59 #1
- Join Date
- Jul 2002
- Along the Wasatch Fault line.
- 0 Post(s)
- 0 Thread(s)
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?