Re: Confused about SQL update

My experience says that it's best that update statement returns more rows that select statement. Try to do this select distinct * from customer where compno =1 and ledger_code = "A" from customer where custno not in (select custno from customer_debt) Perhaps in this 514 records you are counting more than once the sames records. Hope this helps DJMoralesM