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.