Hello,
Does anyone know if the JDBC Adpater supports Outer Joins using the SelectSQL template or do I have to use the CustomSQL template?
Regards,
Mathias
Hello,
Does anyone know if the JDBC Adpater supports Outer Joins using the SelectSQL template or do I have to use the CustomSQL template?
Regards,
Mathias
Better use custom SQL template as this will provide freedom to perform any join u want …
The select template supports outer joins.
I do not see how selectSQL Adapter Template can be used for outer joins. I would think you would simply change the operater for the join, I cannot get either Developer or Designer tochange the join operator to anything other than “=”.
Anyone have any tips on this?
Versions:
wM 8.0.1.0
JDBC Adapter 6.5 SP26.
-Lohr
My apologies. My post about support for outer joins is wrong.
Got it, customSQL Template for Outer Joins.