oracle语句如何转换为access语句，求教高人…

[biduan09]

select d.jh,a.gj yg0_gj1,a.gs yg0_25, b.gj yg0_gj2,b.gs yg0_22, c.gj yg0_gj3,c.gs yg0_19,nvl(a.gs,0)+nvl(b.gs,0)+nvl(c.gs,0) yg0_xj1 from (select jh, gj, count(jh) gs from ys_ddh013 where gzxl = 1 and ggxh like '%25%' and jh=':tj_jh' and wgrq= (select max(wgrq)from ys_ddh013 where jh=':tj_jh' and wgrq < to_date(':tj_wgrq','yyyy-mm-dd')) group by jh,gj) a,(select jh, gj, count(jh) gs from ys_ddh013 where gzxl = 1 and ggxh like '%22%' and jh=':tj_jh' and wgrq= (select max(wgrq)from ys_ddh013 where jh=':tj_jh' and wgrq < to_date(':tj_wgrq','yyyy-mm-dd')) group by jh,gj) b,(select jh, gj, count(jh) gs from ys_ddh013 where gzxl = 1 and ggxh like '%19%' and jh=':tj_jh' and wgrq= (select max(wgrq)from ys_ddh013 where jh=':tj_jh' and wgrq < to_date(':tj_wgrq','yyyy-mm-dd')) group by jh,gj) c, (select ':tj_jh' jh from dual) d where d.jh =b.jh(+) and d.jh=c.jh(+) and d.jh=a.jh(+)

[biduan09]

谢了哈…

[ACMAIN_CHM]

需要改的地方太多了，体力活啊。

你先把 NVL 换成ACCESS的NZ，或者IF （ISNULL
另外把to_date(.....) 直接换成 #2009-10-31#这种格式。

[ACMAIN_CHM]

另外连接换成 left join