I want to know if mysql can merge two tables in a way that one certain column of both tables subtract each other. One table performs a mathematical add operation on the data in its certain column, while it performs a mathematical subtract operation of the certain column from the other table. At the end, it will output an answer for the total of the operation.

I want to use this on my accounting table wherein the CREDIT table is subtracted by the DEBIT table, but i want all the entries to be presented, like Description of Credit, Description of Debit, date, amount, Credit_Transaction_ID, and Debit_Transaction_ID....

Thanks

sounds feasible

you have any idea on how to achieve this?

sure -- start by showing us your JOIN and i can take it from there