This is my error
ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
This is my subquery
(select TOP(1) Error from tablename v, tablename j where v.columname= j.columnname1 ORDER BY v.columnname,j.columnname1)
I'm confused because I am using an order by clause, any idea's?
Thank you in advance