when i want to write sql query based on two tables

Discussions

EJB programming & troubleshooting: when i want to write sql query based on two tables

  1. hello everybody,

    when i want to write a sql query based on two tables for retriving records in session bean for cmp , what should i do?

  2. Complex queries having joins is not possible in CMP Beans with EJB spec 1.0 or 1.1, if you really want to use complex queries in CMP you have to used Software like TopLink. which will map ur complex query to the database.