I have a number of mappers defined in my package which have finder methods with WHERE clauses referencing a single DB table. The DB tables and there fields are defined in the package.
My stateless session beans create action objects and call upon methods to perform various database queries via the perfom methods.
However, I would like to create a slightly more complex mapper class which has a number of my tables in the FROM/WHERE clause in it's finder method.
How can a String for the SQL Prepared statement (which currently references the single table be enhanced to use other tables as well.