SUM of records in two tables using ExecuteSQL()

Discussion created by DavidJondreau on Apr 26, 2013
Latest reply on Apr 30, 2013 by mikebeargie

I'm trying to get the sum of records in two different tables using ExecuteSQL().


I have a date field in two tables (one representing what is paid to workers, the other what is charged a client), along with a total field. I'd like to end up with a list of dates and the totals from each table for each date. I think this is SUM() and a JOIN, but I can't get the totals to come out right...Maybe it's not a join but multiple selects?


Any help would be appreciated.