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 Adaptive Server Anywhere support subqueries in the ON clause.
Full outer join support is as follows:
Adaptive Server Anywhere and Sybase IQ support FULL OUTER JOIN.
Adaptive Server Enterprise does not support FULL OUTER JOIN.
