Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
In-Reply-To: <000d01c81176$a7e1b7e0$f7a527a0$@com>
Subject: RE: Left Join on multiple clauses
To: "Apache Torque Users List" <torque-user@db.apache.org>
Message-ID: 
 <OFBB4E7982.36D94260-ONC1257378.003F5136-C1257378.0040106B@seitenbau.net>
From: Thomas Fischer <fischer@seitenbau.net>
Date: Thu, 18 Oct 2007 13:39:42 +0200
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII


Torque can only create joins using one join statement per join; and the
join operator must be the "equals" operator. If you need something else,
you would have to assemble at least parts of the sql statement manually.

Having said that, I'm not sure whether the statement in your last mail is
correct, but I have not tested it. Make sure you have tested it.

As a last resort, you can always use two selects, one which gets the
records which do have an associated record in the joined table and one
which gets the others.

    Thomas

"Jonathan Halland" <jonathan@spiraleye.com> schrieb am 18.10.2007 13:04:21:

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


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