FN-FORUM: Sort problem

date posted 4th January 2006 22:55

I have the following


select distinct v.Name as Name,Title, Length, Page_Title, Video_Types,
v.Video_Id as Video_Id from videos v left join video_page_index i on
(i.Video_Id = v.Video_Id) left join clients_pages p on (i.Clients_pages_Id =
p.Clients_pages_Id and p.Client_Id = " . $_SESSION['Client_Id'] . ") where
v.Status = 'Active' and i.Status = 'Active' and p.Status = 'Active' order by
v.Name desc, Title asc


It orders by v.Name desc alright but Title within v.Name is not in Ascending
order. Has any one got any ideas why please?


Thanks
Pam