// Script Starts Here

select dn.doid, sum(dn.amount) as amt, 0 as lvid, 0.0 as amt2, 0 as lvid2 
 into memory\WorkA 
 from donation dn 
 where dn.donationdate <= '2013-03-09'
  and dn.batch > 1 
  and dn.NoLevelTF = False 
  group by dn.doid, lvid, amt2, lvid2 
  order by 1;
  
create index iIndex on memory\WorkA (doid);

select dn.doid, sum(dn.amount) as amt, 0 as lvid 
 into memory\WorkB 
 from donation dn 
 where dn.donationdate <= '2012-08-31'
 and dn.batch > 1 
 and dn.NoLevelTF = False 
 group by dn.doid, lvid 
 order by 1;
 
create index iIndex on memory\WorkB (doid);
 
// This Step does not delete all records

Delete from memory\WorkA A
  Inner Join memory\WorkB B on (A.DOid = B.DOid)
  where A.amt = B.amt;
  
// There shouldn't be any records with amt1 and amt2 equal.

Select a.doid, a.amt, b.amt from memory\WorkA A
  Inner Join memory\WorkB B on (A.DOid = B.DOid);