Is there a limit to the number of UNION queries I can run? I'm fine at 2 but with 3 or more, I get this error:
"ODBC -- call failed.
[MySQL][ODBC 3.51 Driver][mysqld-5.0.51a-log] You have an error in your SQL syntax; ..."
I am using MySQL as my backend. I can run the queries with 3 or more UNIONS in the mysql query browser. It just fails with Access. The number of records is small (6 total rows returned with 3 unions).