How do you model for a JOIN operation in a relational database using entity bean(s)? Do you have to have separate entity beans for each table in the database?
A way to do it is to model an Entity for each table and for the join specify a reference to Entity Bean 2 (from table2 ) from Entity Bean 1 (from table 1). If this is a one-to-one relationship then you could easily place these into the same Entity bean - this is a design issue and has other factors involved.
For a one-to-many relationship you could specify a collection of EJB references to Entity Bean 1 inside Entity Bean 2.