sql语句错误

[robot_zyt]

报未指定的错误，各位大虾帮我看看！

select sum(inpayMoney) as 收入金额,
sum(outPayMoney) as 支出金额,
sum(inpayMoney-outPayMoney) as 利润,
sum(inpayMoney-outPayMoney)/sum(inpayMoney) as 纯利润率
from ( select
iif(InpayDate is null, OutPayDate, InpayDate) as DoDate,
iif(InpayMoney is null, 0, inPayMoney) as inPayMoney,
iif(OutPayMoney is null, 0, OutPayMoney) as OutPayMoney
from ( select a.InpayDate,a.InpayMoney,b.outPayDate,b.outPayMoney
from ( select
cdate(left(cstr(format(InpayTime,'yyyy-mm-dd')),10)) as inpayDate,
sum(payMoney) as inpayMoney
from inpay where if_pay='是'
group by cdate(left(cstr(format(InpayTime,'yyyy-mm-dd')),10)))a
full join ( select outpaybill.outpayDate as outPayDate,
outpaybill.TotalMoney as outPayMoney
from outpaybill,outpayType
where outpaybill.outpayTypeID=outpayType.outpayTypeID and outpayType.ifCalCost='是')b
on a.InpayDate=b.OutPaydate) c ) d
where doDate>=:dtFrom and doDate<:dtTo

[WWWWA]

从最内层查询着手，看看是否是记录中内容有问题

[ACMAIN_CHM]

建议上传你的mdb文件，这样方便别人帮你调试。

QQ群 48866293 / 12035577 / 7440532 / 13666209
ACCESS专业论坛
http://www.accessbbs.cn/bbs/index.php .
http://www.office-cn.net/vvb/ .
http://www.accessoft.com/bbs/index.asp .
http://www.access-programmers.co.uk/forums .
.
http://www.office-cn.net/home/space.php?uid=141646 .

[ACMAIN_CHM]

access 中没有full join,

用
select * from a left join b on a.id=b.id
union all
select * from a right join b on a.id=b.id whre a.id is null

这种方式来替代。