Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
select ai.source, sum(api.amt)
from acc_payment ap, acc_payment_item api, acc_item ai
where ap.acc_payment_no = 117227
and ap.acc_payment_no = api. acc_payment_no
and api.acc_item_no = ai.acc_item_no
and ai.source in (1, 3)
group by ai.source;
select ai.source, sum(api.amt)
from acc_payment ap, acc_payment_item api, acc_item ai
where ap.acc_payment_no = 117227
and ap.acc_payment_no = api. acc_payment_no
and api.acc_item_no = ai.acc_item_no
and ai.source in (1, 3)
group by ai.source;
store data for each table in QVD
AI:
Load
SOURCE,acc_item_no FROM acc_item.qvd where match(source,1,3);
innerjoin(AI):
Load AMT,acc_item_no from acc_payment_item.qvd;
innerjoin(AI)
Load acc_payment_no from acc_payment_no.qvd;
FinalTable;
Load sum(AMT) as sum_amt sourceRESIDENT AI Group by source;
Drop table AI;
Thanks for trying, but it's not working.