Listing 2: U UNION ALL V Query That Uses Different Sort Orders
SELECT *
FROM (SELECT 0 AS sortcol, * FROM U
      UNION ALL
      SELECT 1, * FROM V) AS UV
ORDER BY sortcol,
  CASE WHEN sortcol = 0 THEN col1 END,
  CASE WHEN sortcol = 1 THEN col2 END DESC