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.


-----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

	-----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



	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


	So far no such luck.


	Any Help would be immensely appreciated





To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message