select a.STCD,a.TM,a.Z,a.Q,a.XSA,a.XSAVV,a.XSMXV,a.FLWCHRCD,a.WPTN,a.MSQMT,a.MSAMT,a.MSVMT, b.STNM,b.RVNM,b.STLC,b.BGFRYM,c.LDKEL,c.RDKEL,c.WRZ,c.GRZ,c.OBHTZ,c.OBHTZTM,(a.Z-c.WRZ) OWRZ,(a.Z-c.GRZ) OGRZ,(a.Z-c.OBHTZ) OHTZ
from ST_RIVER_R a,ST_STBPRP_B b,ST_RVFCCH_B c
where a.STCD=b.STCD and a.STCD=c.STCD and a.TM between '2009-09-13 13:00:00' and '2009-09-14 13:00:00' and (a.STCD = '30301400' or a.STCD = '30301600' or a.STCD = '30301800' or a.STCD = '30301801' or a.STCD = '30301804') and -5.0<=OWRZ and OWRZ<0 order by a.STCD asc報(bào)錯(cuò)為：“Invalid column name 'OWRZ' ",請指教
1 回答
楊__羊羊
TA貢獻(xiàn)1943條經(jīng)驗(yàn) 獲得超7個(gè)贊
根據(jù)錯(cuò)誤提示“OWRZ是無效的列名”，你看一下a.Z和c.WRZ這兩列的字段類型是否匹配。
- 1 回答
- 0 關(guān)注
- 247 瀏覽
添加回答
舉報(bào)
0/150
提交
取消