Error : The image data type cannot be selected as DISTINCT because is not comparable

See more:

SQL-Server-2005

VB

SQL-Server

, +

Hello everyone,

When I retrieve data using SQL syntax DISTINCT, I get an error "The image data type cannot be selected as DISTINCT because is not comparable".

CommandInv.CommandText = "SELECT DISTINCT I.INV_NO,P.PAINT_IMG,P.PAINT_IMGSIGN,P.PAINT_IMGINVERSO" & _
  ",S.SCULPT_IMG,S.SCULPT_IMGSIGN" & _
  ",J.JEWEL_IMG" & _
  ",W.WINE_IMG" & _
  ",C.CERT_FRONTIMG,C.CERT_BACKIMG " & _
  "FROM INVENTORY.dbo.INVENTORY I " & _
    "LEFT OUTER JOIN INVENTORY.dbo.PAINTING P ON I.PAINT_ID=P.PAINT_ID " & _
    "LEFT OUTER JOIN INVENTORY.dbo.SCULPTURE S ON I.SCULPT_ID=S.SCULPT_ID " & _
    "LEFT OUTER JOIN INVENTORY.dbo.JEWELLERY J ON I.JEWEL_ID=J.JEWEL_ID " & _
    "LEFT OUTER JOIN INVENTORY.dbo.WINE W ON I.WINE_ID=W.WINE_ID " & _
    "LEFT OUTER JOIN INVENTORY.dbo.CERTIFICATE C ON I.CERT_ID=C.CERT_ID OR C.CERT_ID=P.CERT_ID OR C.CERT_ID=S.CERT_ID "

I show the data using datagridview.
Please help me regarding this... Thanks b4