How to use "Union all" in advanced Query?

Can  you please tell how to use Union All in Advanced Query.
Hi Devaraj,

I haven't used it myself, so I hope somebody corrects me if I'm wrong. However, as far as I am aware, it should be the same as using UNION ALL in a regular SQL statement. Since it is a broad question, the best way for you to follow this link to learn more about it in the UNION ALL section of MSDN.

Also, remember to define the correct output structure so that the query result matches it.


Paulo Tavares
Hello all.
Does anyone knows how to explain what's the problem of using UNION in this advanced query?
Testing the query doesn't produce any error, resulting in no rows found.

print screen

I'm using Service Center

Tiago Bernardo
If no rows is the expected result of that particular query then there should be no problem.

The SQL parser for Advanced Queries isn't complete and probably isn't expection a UNION, but in these cases it passes the code directly to the database engine and you shouldn't have any issue with it.

I believe this is one of those warnings that you can (relatively) safely ignore.
Thank you.
Also, if you remove the parenthesis that warning should be gone.

Tiago Simões