tablea: bid name type
1 一 ch
1 one en
2 二 ch
3 三 ch
tableb: bid
1
2
3
left join:
1、select * from tableb b left join tablea a on a.bid = b.bid where a.type='en'
结果:
bid name type
1 one en
2、select * from tableb b left join tablea a on a.bid = b.bid and a.type='en'
结果:
bid name type
1 one en
2 NULL NULL
3 NULL NULL