JDBC Adapter SelectSQL and Outer Joins


Does anyone know if the JDBC Adpater supports Outer Joins using the SelectSQL template or do I have to use the CustomSQL template?


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?

JDBC Adapter 6.5 SP26.


My apologies. My post about support for outer joins is wrong.

Got it, customSQL Template for Outer Joins.