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

[Todd Chapman]

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?

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?

Thanks.

-Todd