I don't think that Criteria supports outer joins. I remember asking the same thing a while back... and or some reason that I can't quite remember, it is more complex to implement this feature than it seemed at first.
-- Bill ----- Original Message ----- From: "Stephen Kowalczyk" <[EMAIL PROTECTED]> To: "Turbine Torque Users List" <[EMAIL PROTECTED]> Sent: Wednesday, December 18, 2002 1:57 PM Subject: outer joins 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 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
