I wondering if it's possible to add additional tables to a query. 

For example, I have a case where I'd like to do something like this: 

        crit = new Criteria();
        crit.addEqualToColumn("primaryIndustryId",
"C_INDUSTRY_CLASSIFICATION.IND_ID");
        crit.addEqualToColumn("C_INDUSTRY_CLASSIFICATION.IND_ID",
"C_INDUSTRY_CLASSIFIC_T.IND_ID");
        crit.addEqualTo("C_INDUSTRY_CLASSIFIC_T.LAN_ID", "60");

The where clause is created correctly, however the C_INDUSTRY_CLASSIFICATION
and C_INDUSTRY_CLASSIFIC_T tables aren't added to the from clause of the
generated SQL.  

Is there a way to get the tables added to the query?

Alan

--
To unsubscribe, e-mail:   <mailto:ojb-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>

Reply via email to