可行的:
select * from tb_zdxm p left join tb_zdxm_plan pl on p.id=pl.pro_id and pl.plan_year='2017' where p.pro_status='审核通过' and p.pro_createuser='zjk'
不行的:
select * from tb_zdxm p left join tb_zdxm_plan pl on p.id=pl.pro_id where p.pro_status='审核通过' and p.pro_createuser='zjk' and pl.plan_year='2017'