Is there anything wrong with the syntax

Prev: Real 10 random records
Next: FROM and JOIN Problems

From: Syphonics via AccessMonster.com on 12 May 2010 22:12

---

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/Forums.aspx/access-queries/201005/1

From: Ken Snell on 12 May 2010 22:29

---

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(a)uwe> wrote in message
news:a7ebbe14e7f5d(a)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/Forums.aspx/access-queries/201005/1
>

From: Syphonics via AccessMonster.com on 13 May 2010 02:25

---

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

 | 
Pages: 1
Prev: Real 10 random records
Next: FROM and JOIN Problems