Entrée - Sorties

SELECT
`invoices`.`total` - `invoices`.`amount_paid`
FROM `invoices`
WHERE `invoices`.`id` = '%ID%' 

==============================================================
SELECT
`debtors`.`debt` - SUM(`transact`.`amount`)
FROM `transact` 

LEFT JOIN `debtors` ON `debtors`.`id`= `transact`.`code`
WHERE `transact`.`code` = '%ID%'

===============================================================