hio tha
I want to apply distinct only for itemname..how can i do that
SELECT DISTINCT items.ItemName, s.names FROM items JOIN sales s ON
Patindex ('%,' + CAST (items.idType as Varchar) + ',%',',' + s.idPr + ',' ) > 0 where iduser = @iduser
Go to the complete details ...