The query to the remote server will be sent in ANSI if all tables in the from clause participate in an ANSI join.
Not sent:
select * from T1 left join T2 on T1.a = T2.a, T3
Sent
select * from T1 Left Join T2 on T1.a = T2.a Left Join T3 on T3.a = T2.a
