SELECT Fax.* FROM Fax INNER JOIN FaxAccess ON Fax.DocumentNumber = FaxAccess.DocumentNumber WHERE FaxTypeId = 2 AND isPublic = 0 AND (FaxAccess.UserAccess LIKE '\Seattle\Police\Detective%' )
SELECT Fax.* FROM FAX WHERE FaxTypeId = 2 AND Fax.isPublic = 1
and both queries return same columns independently but I get following error when I execute the queries with union
Server: Msg 8163, Level 16, State 4, Line 1 The text, ntext, or image data type cannot be selected as DISTINCT.
I would appreciate if someone can help me out. By my question you can guess I am a novice.
Muhammad Imad Qureshi
Joined: Sep 13, 2005
I am found the solution. In one of my column I had an image file. and because I have one image file in one of my columns that I am selecting thats why I should do UNION ALL because The UNION operator by default eliminates duplicate rows from the resultset. The duplicate eliminating operation is similar to a SELECT DISTINCT. You can't use SELECT DISTINCT on a column that is text type or image type or ntext type.