[rt-users] DBIx::SearchBuilder How to make left join with epression?

[Jesse Vincent]

On Jul 28, 2006, at 5:21 PM, Todd Chapman wrote:

> How do I do a left join and join on an arbitrary expression?
> That catch is that I need to refer to the TABLE2 alias in
> the expression?
>

Shouldn't it be enough to use ->NewAlias to create a new alias, pass  
it in as ALIAS2, and go from there?

What are you actually trying to do?

Best,
Jesse

> Also, how can I just give DBIx::SB the proper SQL to run
> in situations where I can't get it to generate the proper
> SQL?

Inside of join conditions, not easily.

Jesse
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060731/7724e432/attachment.sig>