Thanks for the reply Mike...
Taking the semicolon out gives the same message box.
I can run each query separately, and that may be what I have to end up doing right now.
Thanks,
David
Hello:
I am trying to run a union query in a MS Access db with an odbc connection to vfp. The data in both tables have the same format -- they are just diffent years.
SELECT table1.vendor
FROM table1
UNION ALL
SELECT table2.vendor
FROM table2;
This should work, but I don't know why. I am...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.