here is my query:
strSQL="SELECT DISTINCT A.productID,A.accessoryTypeID,P.modelNumber,P.smallImg,P.smallDesc FROM tblAccessories A,tblProducts P " &_
"WHERE P.manufacturerID=" & manufacturer &_
here is what i am trying to do:
I want to get DISTINCT productID from tblAccessories and then using those productIDs i want to pull info from tblProducts.
I know that the DISTINCT works on all column names i provided and some of the collumns are of type TEXT therefore i get this error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
The text, ntext, or image data type cannot be selected as DISTINCT.
i cant change the 'text' of some columns as those contain html contents. So is there anyway i can make this work?