db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Halland" <jonat...@spiraleye.com>
Subject Left Join on multiple clauses
Date Wed, 17 Oct 2007 16:03:37 GMT
 

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

 


Mime
  • Unnamed multipart/related (inline, None, 0 bytes)
View raw message