You have to use pathexpression to build up join queries. Please have a look at query.html in doc folder of the distribution.
cheers, Thomas > -----Urspr�ngliche Nachricht----- > Von: Olmanson, Alan [mailto:alan.olmanson@;firepond.com] > Gesendet: Mittwoch, 6. November 2002 15:18 > An: '[EMAIL PROTECTED]' > Betreff: extra tables in query/criteria > > > > 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> > > -- To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
