Hi, Sorry my tables were messed up before.i am attaching the word doc also with the tables this time. Here is my issue.I have the follwoing 2 tables. products and descMaster
tables. In products table i have the ids for category,supplier,order. the descriptions for these are stored in the descMaster table. I need to create a list of all products with the descriptions instead of IDs.
Basically the sql would be select prodName,descName from products p, descmaster where descid1="category" and descID2= p.categoryID
|
ProdID |
ProdName |
categoryID |
suppID |
ordrID |
|
1 |
Xyzproduct |
CA |
SD |
OD |
|
2 |
ABCprod |
CB |
SE |
OE |
|
3 |
lmnprod |
CC |
SF |
PO |
|
DescID |
DescID2 |
DescName |
|
Category |
CA |
First Category |
|
Category |
CB |
Second category |
|
Category |
CC |
Third Category |
|
Supplier |
SD |
First supplier |
|
Supplier |
SE |
Second supplier |
|
Supplier |
SF |
Third Supplier |
|
Order |
OD |
First Order |
|
Order |
OE |
Second Order |
|
Order |
PO |
Third Order |
|
|
|
|
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
