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
是怎么回事呢?
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
是怎么回事呢?
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.lbdmSQL语句不对,SQL SERVER直接rq>'2014-10-01 00:00:01' and rq<'2014-10-31 23:59:59',
ORACLE使用to_date方法