select b.* from vw_ss_ywjj00 b,ss_ssyjd0 c
where c.SSDH00=55881 and c.SSMZBZ='0' and b.YJDJH0=c.YJDJH0
and b.YJKSBH+0=222
 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 ('0','1','3','4')
 order by b.yjdjh0 --病人费用查询
 
 
 
 select a.* from (
select 1 YSF000,b.* from VW_YJ_YW0000 b,ss_ssyjd0 c  where c.SSDH00= 55881 and c.SSMZBZ='0'  and (b.YJKSBH='222' or b.LBBH00=4)  and b.ZYGHID=2564080
 and ((b.YJDJH0=c.YJDJH0 and b.XMZT00 in ('3','2')) or (b.CXDJH0=c.YJDJH0)) 
 union all
select 0 YSF000,b.* from VW_YJ_YW0000 b,ss_ssyjd0 c  where c.SSDH00= 55881 and c.SSMZBZ='0'  and (b.YJKSBH='222' or b.LBBH00=4)  and b.ZYGHID=2564080
 and b.YJDJH0=c.YJDJH0
 and (not exists (select 'y' from yj_yw0000 a where a.BRID00=b.BRID00 and a.cxdjh0=b.yjdjh0))
 and ((b.cxdjh0=0) or (b.cxdjh0 is null))
 and b.XMZT00 in ('0','1') ) a
 order by yjdjh0---手术费用划价