left join-on-and 与 left join-on-where

 

 

https://blog.csdn.net/liuming690452074/article/details/105965309/