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