When the remote server supports both ANSI joins and T-SQL joins

Queries containing ANSI join syntax are sent using ANSI join syntax. Queries containing T-SQL outer join syntax are sent with T-SQL syntax.