Hello, I have issues while doing join.
When I need to join 2 tables, this is all right.
But when I have a third table included in the query, here come the issues!
SELECT a.book, Sum(a.ACCRUAL+a.VALUE) AS TOTAL_DISC, Sum(b.ACCRUAL+b.VALUE) AS TOTAL_REF, TOTAL_DISC-TOTAL_REF AS PL
FROM TABLE1 AS...