sql陳述句如下：
insert into t_tt(lbdm, lbmc, je, lr) select a.lbdm,a.lbmc,iif(IsNull(b.jehj), 0, b.jehj) as je,0 as lr from t_fylb a left join ( select lbdm,sum(je) as jehj from t_rcfy where rq between #2014-10-01 00:00:01# and #2014-10-31 23:59:59# group by lbdm) b on a.lbdm=b.lbdm
是怎么回事呢？
uj5u.com熱心網友回復：
insert into t_tt(lbdm, lbmc, je, lr) select a.lbdm,a.lbmc,iif(IsNull(b.jehj), 0, b.jehj) as je,0 as lr from t_fylb a left join ( select lbdm,sum(je) as jehj from t_rcfy where rq between #2014-10-01 00:00:01# and #2014-10-31 23:59:59# group by lbdm) b on a.lbdm=b.lbdm
SQL陳述句不對，SQL SERVER直接rq>'2014-10-01 00:00:01' and rq<'2014-10-31 23:59:59'，
ORACLE使用to_date方法
uj5u.com熱心網友回復：
access的sql語法和sql server已經oracle語法是不一樣的。不能簡單的復制粘貼。如果你在做移植的話可能要整體考慮這個問題了，不是只有這一條陳述句uj5u.com熱心網友回復：
關注uj5u.com熱心網友回復：
SQL陳述句有錯誤造成的。轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/95923.html
標籤：數據庫相關
下一篇：Delphi 呼叫EMail程式