Hi,
something like the following should work:
Criteria crit = new Criteria();
crit.addAlias("LOCAL2", LocalisationPeer.TABLE_NAME);
crit.addJoin(LocalisationPeer.LOC_ORGANISME, "LOCAL2".LOC_REGIONADMIN);
crit.add(LOC_IR, "SudOuest");
LocalisationPeer.doSelect(crit);
Please have a try,
Patrick
Bertrand VENZAL schrieb:
Hi,
I ve got a problem to write a query with Torque with a join on the same
table, is there a way to do it by using only one query.
My query syntax looks like that
select DISTINCT a.* from localisation a , localisation b where
b.loc_IR="SudOuest" and b.loc_regionAdmin=a.loc_organisme;
My table
LOCALISATION
ID | loc_organisme | loc_regionAdmin | loc_IR |
1 | Bordeaux | Aquitaine | SudOuest
|
2 | Aquitaine | NULL | NULL |
My query should return the second row.
I probably miss a torque function that should allow that.
Thanks for your help
Bertrand
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
