db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Halland" <jonat...@spiraleye.com>
Subject RE: Left Join on multiple clauses
Date Thu, 18 Oct 2007 11:04:21 GMT
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:CarlM@ACTIVX.com] 
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:jonathan@spiraleye.com] 
	Sent: Wednesday, October 17, 2007 9:04 AM
	To: torque-user@db.apache.org
	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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message