?? sql.txt
字號(hào):
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 = 'A76' 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 = 'A76' 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='A76'
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 '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.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 = 'A003' 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 = 'A003' 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='A003'
select distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A006' 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 = 'A006' 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='A006'
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 = 'A55' 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 = 'A55' 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='A55'
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 'B%'
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -