If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Is there anything wrong with the syntax
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; -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1 |
#2
|
|||
|
|||
Is there anything wrong with the syntax
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. -- Ken Snell http://www.accessmvp.com/KDSnell/ "Syphonics via AccessMonster.com" u25414@uwe wrote in message news:a7ebbe14e7f5d@uwe... 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; -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1 |
#3
|
|||
|
|||
Is there anything wrong with the syntax
Thanks a lot its works!
Ken Snell wrote: 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; -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|