1、select * form tab1 left join tab2 on (tab1.size = tab2.size) where tab2.name=’AAA’ 2、select * form tab1 left join tab2 on (tab1.size = tab2.size and tab2.name=’AAA’) 其实以上结果的关键原因就是left join,right join,full join的特殊性,不管on上的条件是否为真都会返回lef...