Select pkm_djlx,pkd_bldh,pkd_wldm,pkd_kwdm,pkd_cwdm,pkd_ylsl From pkd_det Join pkm_mstr On pkd_bldh=pkm_bldh Where pkm_djlx In ('MOL','SOL') And pkm_zt='1' Union
Select trm_djlb,trd_djbh,trd_wldm,trd_kwdm,trd_cwdm,trd_yfsl From trd_det Join trm_mstr On trd_djbh=trm_djbh Where trm_djlb='NPL' And trm_zt='1' Union
Select tra_djlx,tra_djbh,tra_wldm,tra_kwdm1,tra_cwdm1,tra_sqsl From tra_mstr Where tra_zt='1' And tra_djlx In ('INJ','INZ') Union
Select 'GEM',ged_djbh,ged_wldm,ged_kwdm,ged_cwdm,ged_sqsl From ged_det Join gem_mstr On ged_djbh=gem_djbh Where gem_zt='1' Union
Select 'SHM',shd_djbh,shd_wldm,shd_kwdm,shd_cwdm,shd_sqsl From shd_det Join shm_mstr On shd_djbh=shm_djbh Where shm_zt='1'