For detailed information on Transact-SQL outer joins, including ANSI syntax alternatives, see the white paper “Semantics and Compatibility of Transact-SQL Outer Joins,” from MySybase. Although written for SQL Anywhere, the information in this document also applies to Sybase IQ.