Could someone assist me on how I should syntax this sql union query to return the sum of sales.charge and visits.charge?
I have tried several methods to no avail :(
SELECT SALES.DATE, [SUDDLE] & " " & [FIRSTNAME] AS FIRSTNAME, SALES.CHARGE, "SALES" AS SourceTable
FROM (INNER JOIN CUSTOMER...