Comparison between two tables and display the outcome on one column using the API_DoQuery

Good Day I am an intern at an ISP assigned to develop a Reconciliation between bank deposits and the amount floated to vendors. I am having a problem with comparing the two different fields and dis...