For detailed information on Transact-SQL outer joins, including ANSI syntax alternatives, refer to the white paper “Semantics and Compatibility of Transact-SQL Outer Joins,” which is available on the Sybase online support Web site MySybase. Although written for Adaptive Server Anywhere, the information in this document also applies to Sybase IQ.