SELECT
lb.WZ_TYPE,jx.WZpl,wz.WZPL,lb.id ,bs.SHORT_NAME
FROM
ZT_WZB_WZINFO lb
left join ZT_WZB_FGSSJY_JX JX ON lb.ID=JX.WZPL
left join ZT_WZB_FGSSJY_WZ WZ ON lb.ID=WZ.WZPL
left join BSP.PUB_ORGAN bs ON bs.CODE =JX.ORG_CODE or bs.CODE =WZ.ORG_CODE
四表查询
最新推荐文章于 2022-10-06 20:42:36 发布