Query with union clause

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

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

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