Treat the view as a table, put the order by on the select from the view, not in the view.