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
PGP.sig
Description: This is a digitally signed message part
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
