Union All - 07-18-2003 , 02:25 PM
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'
SELECT * FROM DB2 WHERE merk = 'Example'
This is the error message:
ADODB.Recordset.1 error '80004005'
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax.........
Please help me!
Posted via http://dbforums.com
Re: Union All - 07-18-2003 , 10:20 PM
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!