sql语句之部分左连接

select * from
base_ware_area a join base_ware_zone b
on a.id=b.areaid
join base_ware_pos p
on b.id=p.zoneid
join base_warehouse d
on a.warehouseid=d.id
join base_ware_postype e
on p.postypeid=e.id
left join base_goods_status f
on b.moveinstatusid=f.id
where
a.bicon_state=1

每个join之后的on里面 都有个与新加的表相对应的id跟之前的相链接,自己测过,顺序不能颠倒