Hi!!

I desperately need help! When I upload the following code to the server
of my provider I receive an unclear error message. I don't have any idea
what I am doing wrong.

This is the code:
SELECT * FROM DB1 WHERE merk = 'Example'
UNION ALL
SELECT * FROM DB2 WHERE merk = 'Example'

This is the error message:
ADODB.Recordset.1 error '80004005'

SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax.........


Please help me!

Greetings,
Maurice

--
Posted via http://dbforums.com

Do both tables have the same number and type of columns? If not you can
not use union all.

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!