Order by problem after Joining the two tables

[nivaspm]

Here is my query.

i specified it for order by x.xref_id, but it is not ordering according to that. what will the problem ...?

select DISTINCT n.id,n.title from article_en as n left join article_en_xref as x on n.id=x.article_en_id where(n.id=x.article_en_id and n.date= curdate() and n.topic <> 12) or (n.date= curdate() and x.article_en_id is null and n.topic <> 12) order by x.xref_id desc,n.creation_time desc

[tsinka]

Hi,

I'm not sure because I can't test it now but I think you also have to select the two fields you want to order by.

[nivaspm]

the result will give repet even if i give disitnct

[tomhath]

It doesn't make sense to order by x.xref_id when you are using a DISTINCT and xref_id is not one of the values being selected.

The value you want to order on is not in the result set, the database doesn't have the data you want to sort.