Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 769
  • Last Modified:

UNION query and image data type

I have a UNION query that defines a view.  One of the columns in the query is a image data type.  When I try to save the view, I get this message:

"The image data cannot be selected as DISTINCT because it is not comparable".  

I understand how image data is not comparable, but where is the DISTINCT coming from?  I am not specifying DISTINCT.  Is there a way around this?
0
HLRosenberger
Asked:
HLRosenberger
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
UNION is a implicit DISTINCT.

please use UNION ALL
0
 
HLRosenbergerAuthor Commented:
Thanks!
0
 
HLRosenbergerAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now