如何把ORACLE的SQL语句转换成ACCESS可执行的SQL语句?
siclj 2000-02-16 10:08:00 Update SWAPACT SET RESID_SI=(SELECT SUM(C.AMOUNT)
FROM SWACTHD b,SWACTDTL c
where SWAPACT.PACTNO=b.PACTNO and b.ADRESSLB='S'
and b.CTCODE=c.ctcode and SWAPACT.SQCNUM=C.SQCNUM
and b.CTLB in('进口','出口')) where PACTNO='11111'
这个sql在oracle中可以执行,在ACCESS中好像得用 INNER JOIN
修改.我没用过ACCESS,能帮帮忙吗?