
December 12th, 2002, 09:59 AM
|
 |
Contributing User
|
|
Join Date: Oct 2002
Location: Norwich, UK
Posts: 84
Time spent in forums: 3 h 50 sec
Reputation Power: 11
|
|
Help in building advanced query
Hi all,
I need to build an SQL query invloving 3 tables and I'm a bit stuck (it's that time of day).
I have the following three tables:
Mat2Prod, with columns "Code" and "Product"
Mat2Age, with colums "Code" and "Age"
Mat, with "Code" (and others)
I need to find all rows in Mat where Product = $var1 and Age = $var2, with both of the $vars given.
I've done joins before with 2 tables but with three my head starts hurting. Any help appreciated!
__________________
Yours,
Frank Reding, IconoclastDesign.co.uk.
|