Devart Forums

First of all I have to say that I LOVE your software I'm kind of newbie on this. I want to create following query with Query Designer but I'm not sure how to do it, so I really appreciate if anyone can help me with this:

SELECT ID,[Name],[Description] FROM Table_1
UNION
SELECT ID,[Name],[Description] FROM Table_2

Unfortunately, UNION statements are not supported by Query Builder.

You need to design first query, copy its text to another SQL document.
Then design the second query and append its text to the first one (putting UNION between).