If I move the CAMPAIGN_ID=16 to the where clause I will essentially have the same as a inner join, I however need to access the records that do not necessarily have a matching record in the right side table.
Regards JOnathan -----Original Message----- From: Manaster, Carl [mailto:[EMAIL PROTECTED] Sent: 17 October 2007 06:09 PM To: Apache Torque Users List Subject: RE: Left Join on multiple clauses Hi, Jonathan, As I see it, "joining" to a constant doesn't really make sense, although it might work in some or all cases, might even be perfectly valid syntactically. I would move the CAMPAIGN_ID=16 test to the WHERE clause. Peace, --Carl -----Original Message----- From: Jonathan Halland [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 17, 2007 9:04 AM To: [email protected] Subject: Left Join on multiple clauses Hi, I'm new to this list, but I've been struggling for quite a while to get the following right. I need to do a left join on two clauses e.g. LEFT JOIN campaign_handled_objects on accounts.ACCOUNT_ID=campaign_handled_objects.OBJECT_ID AND campaign_handled_objects.CAMPAIGN_ID=16 So far no such luck. Any Help would be immensely appreciated Regards Jonathan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
