Select Distinct Error ??

[darkos32]

hi,all....i got this error :

ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

my query is :

select distinct(t1.[name]) from [test1] as t1,[test2] as t2 where t1.[name]=t2.[name] order by t2.[id] asc

when i used this query at mysql,i didnt got any error,but when i try to change to sql_server,i got error.....i want to get distinct name from table one and order by table2.id..


thanks.

[tveringa]

Hi

This should work :

select distinct(t1.[name]), t2.[id] from [test1] as t1,[test2] as t2 where t1.[name]=t2.[name] order by t2.[id] asc

Ton

hi,all....i got this error :

ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

my query is :

select distinct(t1.[name]) from [test1] as t1,[test2] as t2 where t1.[name]=t2.[name] order by t2.[id] asc

when i used this query at mysql,i didnt got any error,but when i try to change to sql_server,i got error.....i want to get distinct name from table one and order by table2.id..


thanks.

[darkos32]

yes...but it's not a distinction again........i got double column of name...

[jobspider1000]

Hi

The reasons and ways to avoid this error have discussed in this

site with good examples. By making small changes in the query

http://sqlerror104.blogspot.com/2009/08/order-by-items-must-appear-in-select_19.html