Good day ,
I am trying to customize a union query someone made for me a long time ago.
I have two queries with field names as follows:
SELECT Previous Billing.*, Current Billing.Previous Balance Due AS PreviousBalance, NULL AS Current Balance Due
FROM Previous Billing
UNION ALL SELECT Current billing.*, NULL AS Previous Balance Due, Current billing.Current Balance Due AS Current Balance
FROM Current billing;
query named Current Billing with field current balance due query named Previous Billing with field previous balance due
I am getting a syntax error in previous billing but cant see the error.
Grateful for assistance