i solve it by this code
===========================================
select code,client_name,amount,pa,amount-pa as re from
(SELECT clients.code,client_name,clients.amount,(
SELECT SUM(amount) AS Expr2 FROM payments WHERE (clients.code=payments.code)
) AS Pa FROM clients) as dd
many thanks