Is there anything wrong with the syntax

[Syphonics via AccessMonster.com]

It gave me synatx error from clause?

SELECT GL Finance Credit Query.* FROM GL Finance Credit Query
UNION ALL SELECT GL Finance Debit Query.* FROM GL Finance Debit Query;

 

[Ken Snell]

SELECT [GL Finance Credit Query].* FROM [GL Finance Credit Query]
UNION ALL SELECT [GL Finance Debit Query].* FROM [GL Finance Debit
Query];


You must delimit the query names with square brackets because the query
names contain spaces.

 

[Syphonics via AccessMonster.com]

Thanks a lot its works!

SELECT [GL Finance Credit Query].* FROM [GL Finance Credit Query]
UNION ALL SELECT [GL Finance Debit Query].* FROM [GL Finance Debit
Query];

You must delimit the query names with square brackets because the query
names contain spaces.

It gave me synatx error from clause?

SELECT GL Finance Credit Query.* FROM GL Finance Credit Query
UNION ALL SELECT GL Finance Debit Query.* FROM GL Finance Debit Query;