Using 5.0 build 689.
This is a similar question to very recent thread called "Charts and Union Queries".
Am in a Custom View trying to select from several similar tables using a simple UNION statement like this:
SELECT col1, col2
from tablea
UNION
SELECT col1, col2
from tableb
The Results tab shows that it is working perfectly.
However, once the project is built, only results from the first Select are shown.
If I flip the Selects, then the new one on top works.
If I place parentheses () around the Selects (according to MySQL Doc) the query blows up.
So, am I doing something wrong or did I stumble on a bug?
Incidentally, the 5.0 Documentation says UNION queries ARE supported.