Update Customer; SET ; Debit = CrsCurrent.Debit, ; Credit = CrsCurrent.Credit ,; Balance = CrsCurrent.Balance ; From CrsCurrent ; where CrsCurrent.custID = Customer.custID