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!
