On Mon, Jul 31, 2006 at 12:34:11PM -0400, Jesse Vincent wrote: > > 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?
I am doing a LEFT join and my additional criteria needs to be in the ON clause. And my criteria needs to refer to the 'right' table? With a left join SB requires TABLE2 instead of ALIAS2. Does this make sense? > > 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 _______________________________________________ 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
