db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Derek Hardy" <derek.ha...@teknosys.co.uk>
Subject Question regarding Peers, Joins and Criteria
Date Tue, 13 May 2003 08:32:12 GMT
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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message