db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stephen Kowalczyk" <steph...@cooper-software.com>
Subject outer joins
Date Wed, 18 Dec 2002 18:57:52 GMT
Anyone know how to create an outer join using criteria?

I use:

CRITERIA.addJoin(SCDUsageDataPeer.REGISTRATIONID, SCDRegistrationPeer.SCDREGISTRATIONID);
 
and get a select that uses:

FROM SCDUsageData, SCDRegistration WHERE SCDUsageData.REGISTRATIONID=SCDRegistration.SCDREGISTRATIONID


when what I want is:

FROM SCDUsageData LEFT JOIN SCDRegistration ON SCDUsageData.REGISTRATIONID=SCDRegistration.SCDREGISTRATIONID


Basically, I want all the rows from SCDUsageData regardless of whether they have a matching
row in SCDRegistration.

Thanks,

Stephen
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message