Thread: UNION in SQL
View Single Post
  #2 (permalink)  
Old July 27th, 2010, 07:43 AM
joefawcett's Avatar
joefawcett joefawcett is offline
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

Because UNION (without ALL) deduplicates and to do this it has to compare data which it can't do for IMAGE type fields. Just as you can't sort on such types.
__________________
Joe
http://joe.fawcett.name/
Reply With Quote