Hello, I am having trouble summing two different amounts from two different tables (BILLs & BillPayment).
I am trying to sum All Bills Amount in 2nd column and All BillPayment Amount in 3rd column, based on CustomerID in 1st column, but getting wrong results. Please help. Sample DB file is attached