The SQL/2003 join syntax that uses a table expression in the FROM clause is supported. See FROM clause.

Support for Transact-SQL outer join operators *= and =* is deprecated. To use Transact SQL outer joins, the tsql_outer_joins database option must be set to On. See tsql_outer_joins option [compatibility].