I have access as the front end an mysql as the back end, i am trying
to do a Union query but get the following errors

can any one help

ODBC - Call Failed
[MySQL][ODBC3.51 Driver][mysql-4.1.22-standard] You have an error in
your SQL syntax: check the manual that corresponds to your MySQL
server version for the right syntax to use near Union( SELECT
'tblcodesWS' , 'tblProductsWS' , 'ProductName' , ' tblPr' at line 1
(#1064)

On 19 May, 10:41, S.****...@shos.co.uk wrote:
> I have access as the front end an mysql as the back end, i am trying
> to do a Union query but get the following errors
>
> can any one help
>
> ODBC - Call Failed
> [MySQL][ODBC3.51 Driver][mysql-4.1.22-standard] You have an error in
> your SQL syntax: check the manual that corresponds to your MySQL
> server version for the right syntax to use near Union( SELECT
> 'tblcodesWS' , 'tblProductsWS' , 'ProductName' , ' tblPr' at line 1
> (#1064)

If we knew what the query was we might be able to!
A space between UNION and ( might help.