Support for ANSI join syntax can be summarized as follows:
IQ does not currently support subqueries in the ON clause.
Adaptive Server Enterprise and Adaptive Server Anywhere do support them.
Full outer join support is as follows:
Adaptive Server Anywhere and IQ support FULL OUTER JOIN.
Adaptive Server Enterprise does not support FULL OUTER JOIN.
