I tried to run this query

delete from claim_detail where;
claim_detail.line = claims02.Line and;
claim_detail.claim_num = claims02.claim_num

This query seems to be running but does not delete the rows. I know this query should delete 140 records as this select query.

select claim_detail.* FROM claim_detail, claims02;
where claim_detail.line = claims02.line and;
claim_detail.claim_num = claims02.claim_num

returns 140 records. Actually these 140 records I want to delete from the claims_detail table.

Thanks for your concern
Bhushan