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

Reply via email to