Re: SQL - delete with ... select by two fields?

I think the following script properly mimics the given scenario, and hopefully provides the proper DELETE statement logic:

create table qtemp.batchdet (doc_nr int, batch_nr int, amount int)
;
insert into qtemp.batchdet values
(1, 1, 100), (1, 1, -100), (1, 2, 100), (1, 2, -120), (3, 4, 100)
;
delete from qtemp.batchdet m
where exists (select 1 from qtemp.batchdet s
where m.doc_nr = s.doc_nr and m.batch_nr = s.batch_nr
group by s.doc_nr, s.batch_nr having sum(s.amount)=0 )
;
select * from qtemp.batchdet
DOC_NR BATCH_NR AMOUNT
1 2 100
1 2 120-
3 4 100
******** End of data ********

Regards, Chuck