db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alvin Antony" <Alvin.Ant...@internet.lmu.de>
Subject Antw: Question regarding Peers, Joins and Criteria
Date Tue, 13 May 2003 12:34:39 GMT
http://db.apache.org/torque/criteria-howto.html

HTH,

Alvin

>>> derek.hardy@teknosys.co.uk 05/13 10:32  >>>
Hi

I'm trying to create a method in the PropertyPeer to reproduce the
following
SQL query

select *
  from property p
      ,property_stores s
 where p.store_id = s.store_id
   and s.owner_id = 1;

How do I define the criteria to add a restriction on the join table.

Thanks

Derek

Mime
View raw message