Page 1 of 1

Query with union clause

Posted: Sat 16 Aug 2014 15:08
by robw92
Good morning,

I have a query that looks like this:

"SELECT * FROM zips.zips

WHERE County = 'fairfield' AND State = 'ct'

UNION

SELECT * FROM zips.zips

WHERE County = 'TIOGA' AND State = 'ny'


When I paste it into a new sql window, it executes fine. However when I save it & try to rerun it, it throws and error with no message.

Can someone explain in some detail how a group by workaround might be accomplished? Thanks in advance.

Re: Query with union clause

Posted: Mon 18 Aug 2014 07:17
by alexa
Could you please provide us the edition and version of dbForge and a screenshot of the error message?

You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via e-mail.

Re: Query with union clause

Posted: Thu 04 Sep 2014 09:34
by alexa
Also, you can vote for the following suggestion on our UserVoice forum http://devart.uservoice.com/forums/7729 ... ctionality

We collect and analyze the information from this forum in order to make a proper roadmap for future product releases.