definition of SQL clause in DDE finder panel

[michael earnshaw]

i'm new to CMP EJBs and using JBuilder to develop them.

i am attempting to create a finder method for a CMP EJB using the finder
panel in JBuilder's DDE. Here's the problem:

i want to use another table to join between the table my criteria is from
and the table my results are from. for example,

/**returns a collection of As*/
Collection findByC(C c)

table A
-------
A_ID
B_ID
name

table B
-------
B_ID
C_ID

table C
-------
C_ID

How do i phrase the where clause in the finder panel to achieve this end?

[Krishnan Subramanian]

Michael,

Please refer to the AppServer example (pigs) which illustrates
relationships. Also the EJB programmer's guide contains some
information in the section pertaining to advanced cmp issues.

-krish

"michael earnshaw" <mike_e...@mentor.com> wrote in message news:3bd6d25d$1_2@dnews...