Microsoft SQL Server supports outer joins between two or more tables. Outer joins can be passed down to be processed in Microsoft SQL Server. However, the outer joins must not be mixed with inner joins in a query.
For more information about when and how SAS/ACCESS passes joins to the DBMS, see Passing Joins to the DBMS.