栾珠(提问者)我修改了下日期,改为日期期间,然后就都查不出数据来,阅览数据列名出线了小问号
select z.*,z1.*,z.qty1-z1.qty2 from (
select costcenter cost1,acctitem act1,sum(t.invwgt) qty1 from db.tbiptdok t
where length(t.compid)=4 and t.acctdate between\'${monthsFrom}\' and \'${monthsTo}\' group by costcenter,acctitem
)z
full join(
select t1.costcenter cost2,acctitem act2,sum(t.invwgt) qty2 from db.tbagiptdok t
left join (select * from db.tbacb1r where acctmonth=to_char(sysdate,\'yyyy\'))t1
on t1.costcenterm=t.costcenter
where t.acctdate between\'${monthsFrom}\' and \'${monthsTo}\' group by t1.costcenter,acctitem
)z1
on z1.cost2=z.cost1 and z1.act2=z.act1
where z1.qty2 is null or z.qty1 is null or z.qty1-z1.qty2<>0