On Mon, Jul 31, 2006 at 12:50:42PM -0400, Todd Chapman wrote: > 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
Do you have any suggestions when doing a left join or does SB need some extra magic? -Todd _______________________________________________ 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
