17,086
社区成员
发帖
与我相关
我的任务
分享
select distinct mbrid,dos from fi05 where
(
dx1 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or dx2 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
......
or dx9 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
)
and
(
(
((cpt between '99217' and '99220') or (cpt between '99234' and '99236'))
or ((cpt1 between '99217' and '99220') or (cpt1 between '99234' and '99236'))
..........
or ((cpt9 between '99217' and '99220') or (cpt9 between '99234' and '99236'))
)
or
(
((rev between '0500' and '0529') or (rev between '0570' and '0599') or (rev between '0770' and '0779') or (rev between '0820' and '0859' )
or (rev between '0982' and '0983') or (rev = '0882'))
or((rev1 between '0500' and '0529') or (rev1 between '0570' and '0599') or (rev1 between '0770' and '0779') or (rev1 between '0820' and '0859')
or (rev1 between '0982' and '0983') or (rev1 = '0882'))
...............
or ((rev9 between '0500' and '0529') or (rev9 between '0570' and '0599') or (rev9 between '0770' and '0779') or (rev9 between '0820' and '0859')
or (rev9 between '0982' and '0983') or (rev9 = '0882'))
)
)
create view test_dx as select distinct mbrid,dos from fi05 where
(
dx1 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
........
or dx9 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
)
create view test_cpt as select distinct mbrid,dos from fi05 where
(
((cpt between '99217' and '99220') or (cpt between '99234' and '99236'))
....
or ((cpt9 between '99217' and '99220') or (cpt9 between '99234' and '99236'))
)
create view test_rev as select distinct mbrid,dos from fi05 where
((rev between '0500' and '0529') or (rev between '0570' and '0599') or (rev between '0770' and '0779') or (rev between '0820' and '0859' )
or (rev between '0982' and '0983') or (rev = '0882'))
........
or ((rev9 between '0500' and '0529') or (rev9 between '0570' and '0599') or (rev9 between '0770' and '0779') or (rev9 between '0820' and '0859')
or (rev9 between '0982' and '0983') or (rev9 = '0882'))
select b.mbrid from fi05 a,test_dx b,test_cpt c,test_rev d where a.mbrid = b.mbrid and (a.mbrid = c.mbrid or a.mbrid = d.mbrid)