I want to do select query which delas with 2 tables in the database.
How do I do it thru' CMP beans ?
Will I need to write 2 beans which maps 2 tables and then single
deployement discriptor where I need to specify 2 bean entries ?
I need to write SELECT clause. I'm using EJB2.0, WLS6.0
and I don't have any relationship with beans. All I wanna do is,
SELECT t1.id, t1.name FROM table1 t1, table2 t2
WHERE t1.id = t2.id AND t1.type = 'T5S' AND t1.SeqNum = '1' "
AND t1.state= 'TX'"
Wheather I need to use EJB QL ?
How can I do the above ? any example, url, info ... is welcome.