Left Join on multiple clauses

[Jonathan Halland]

 

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