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.