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 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
How can I get this in OJB.
Thanks a lot,
Krupa
---------------------------------
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
