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
