Transact-SQL outer joins

Supported syntax for outer joins can be summarized as follows:

Note T-SQL outer join syntax is deprecated in Adaptive Server Anywhere and IQ.