I was able to use order by for multiple columns in a join view. I used a query that looked like the following example:
select * from <view_name> order by <column_ name1> desc, <column_ name2> asc;
I can add as many columns as I want to the order by clause if I keep adding a comma after each column name.
For an overview of the order by clause please check out the [ORDER BY Clause](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/queries_select_statement/order_by_clause/order_by_clause) section of the Virtual DataPort VQL Guide.
Hope this helps!