Union Query

[chavez_sea]

Good day ,


I am trying to customize a union query someone made for me a long time ago.

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;

I have two queries with field names as follows:

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

[ranman256]

i find it easier to make my individual queries and not have to debug 1 massive union query:
select * from Query1
union

select * from Query2

[pbaldy]

The spaces in your names are not advisable and have to be bracketed when used, like:

[Previous Billing]

[chavez_sea]

Thanks. So in this case how would my query look. I am not good at union queries.

[pbaldy]

If that's directed at me, either get rid of the spaces in your object names (preferable) or put square brackets around any table/query/field name that has one or more spaces in it.

[chavez_sea]

Thank you. Will amend and see how it works.