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
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
I have to list the products with the category description,supplier description,
order description.
How do I achieve this with OJB.
please help.
Thanks,
Krupa
I have a table products which has prodid,prodname,categoryid,listid.
the description for categories is in a descmaster table.
---------------------------------
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
