Return
-
Title
When doing a Group Execute on one table in two databases in MySQL, the result set only shows from one table -
Description
In the Editor, when doing a Group Execute on one table in 2 MySQL databases, the result set only shows from one table.
The workaround is to run the statement manually, such as:
select column FROM db01.table1
UNION ALL
select column FROM db02.table1;
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.