retrieve description

[krupa B <kr...@yahoo.com>]

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