on与where的区别
[code="java"]
select b.town_id ,a.school_name from school a left join town b on (a.town_id = b.town_id); --416
select b.town_id ,a.school_name from school a left join town b on (a.town_id = 110108 a...
原创
2014-05-28 11:15:16 ·
176 阅读 ·
0 评论