Re: EJBs help me

[Koneti Kavi Kumar]

Hi,   Using BMP or using third party OR-Mapping tools (Ex. TopLink) is the best way to solve this situation.   Regards, Kavi ----- Original Message ----- From: Maya menon To: [EMAIL PROTECTED] Sent: Friday, October 04, 2002 12:24 AM Subject: EJBs help me Hi, Let me explain what am I try to do with EJBs here. I have to get 3 values from 2 tables, SAY PRODUCT TABLE AND CUSTOMER TABLE (AS AN EXAMPLE) Customer table has 2 fields, Customer_ID( Primary key) and CustName PRODUCT TABLE has three fields, ProductName, Desc and CustID(which is a foreign key)[This table doesnt have a PK] I am getting productname, desc and custName from the two tables where CustID is the same. So, this can be done with the simple SQL statement. select b.PRODUCTNAME, B.DESC, A.CUST_LISTED_NAME FROM PRODUCTS B, CUSTOMER A WHERE A.CUSTOMER_ID = '11111' Now I want to create two EJBs and select this custName, or findByCustID How do I approach this situation. Which is the best way ? Any suggestions are welcome Thanks, Maya Do you Yahoo!? New DSL Internet Access from SBC & Yahoo!