sql.txt

专业的办公oa代码下载 c#语言编写 三层结构

select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'B001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'B%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'B001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'B206'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'B206'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select WLBZDMC,WJBDM from MIS_WLBDY Where len(WJBDM)>0 AND WJBLX='1' AND WLBDM='B206'
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A07'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A07'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select WLBZDMC,WJBDM from MIS_WLBDY Where len(WJBDM)>0 AND WJBLX='1' AND WLBDM='A07'
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A002'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A002'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select WLBZDMC,WJBDM from MIS_WLBDY Where len(WJBDM)>0 AND WJBLX='1' AND WLBDM='A002'