Hi,
Sorry my tables were messed up before.
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 wi
Hi,
I have 2 tables.
Table1
Products
prodID int
prodName varchar
categoryID char
suppID char
ordrID char
ProdID
ProdName
categoryID
suppID
ordrID
1
Xyzproduct
CA
SD
OD
2
ABCprod
CB
SE
OE
3
lmnprod
CC
SF
PO
Table 2
DescMaster
DescID
DescID2
DescName
Category