?? sql.txt
字號:
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'
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -