db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Patrick Carl <patrick.c...@web.de>
Subject Re: Query with Torque
Date Fri, 25 Nov 2005 18:36:31 GMT
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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message