UNION in Query Designer

qorbani · Post by **qorbani** » Thu 11 Aug 2011 21:29

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

Duke · Post by **Duke** » Fri 12 Aug 2011 11:10

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).