select b.*,C.SSDH00 SSDH00 from vw_ss_ywjj00 b,ss_ssyjd0 c
where c.SSDH00='78186' and c.SSMZBZ='0' and b.YJDJH0=c.YJDJH0
and b.YJKSBH=22
 and b.ZYGHID=849200
 and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0))
 and ((b.cxdjh0=0) or (b.cxdjh0 is null))
and b.XMZT00 in ('4','3','2')
 order by b.yjdjh0