select b.purchid, c.purchname, c.orderaccount, sum(a.amountmst), a.dimension
from ledgertrans a
inner join vendpackingslipjour b on a.voucher = b.ledgervoucher
inner join purchtable c on b.purchid = c.purchid
where 
a.accountnum = '34050'
and a.dataareaid = 'agl'
and b.dataareaid = 'agl'
and a.voucher like 'GRN-%'
and transdate < '2012-04-01'
and b.purchid = 'PO-000662'
group by b.purchid, c.purchname, c.orderaccount, a.dimension

select b.purchid, c.purchname, c.orderaccount, sum(a.amountmst), a.dimension
from ledgertrans a
inner join vendinvoicejour b on a.voucher = b.ledgervoucher
inner join purchtable c on b.purchid = c.purchid
where 
a.accountnum = '34050'
and a.dataareaid = 'agl'
and b.dataareaid = 'agl'
and a.voucher like 'PI-%'
and transdate < '2012-04-01'
and b.purchid = 'PO-000662'
group by b.purchid, c.purchname, c.orderaccount, a.dimension

quote:

---

purchid purchname orderaccount amount dimension
PO-000662 POD ODO001 -45444.870000000000 BEL
PO-000662 POD ODO001 -81151.510000000000 FMT

---

purchid		purchname	orderaccount	amount			dimension
PO-000662	POD		ODO001		45444.870000000000	BEL
PO-000662	POD		ODO001		80363.180000000000	FMT

quote:

---

purchid purchname orderaccount amount dimension
PO-000662 POD ODO001 0.000000000000 BEL
PO-000662 POD ODO001 -788.330000000000 FMT

---

; with
q1 as
(
    < query 1 >
),
q2 as
(
    < query 2 >
)
select < do you calculation here example : q1.col1 - q2.col2 >
from   q1 inner join q2 on q1.purchid = q2.purchid

select b.purchid, c.purchname, c.orderaccount, sum(a.amountmst), a.dimension
from ledgertrans a
inner join (
select purchid,ledgervoucher
from vendinvoicejour 
where  dataareaid = 'agl'
union all
select purchid,ledgervoucher 
from vendpackingslipjour 
where  dataareaid = 'agl'
)b on a.voucher = b.ledgervoucher
inner join purchtable c on b.purchid = c.purchid
where a.accountnum = '34050'
and a.dataareaid = 'agl'
and a.voucher like 'PI-%'
and transdate < '2012-04-01'
and b.purchid = 'PO-000662'
group by b.purchid, c.purchname, c.orderaccount, a.dimension