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
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 (186 Bytes)
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?
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