applying arithmetic functiojn on different tables in mysql : i have two tables
table1 sanction
table2 collection
i want to select amount from sanction - amount recovered from collection 
and output the difference.
select SUM(sanction.san_recover-collection.amount) as total where client_id=?