1 Reply Latest reply on Jul 13, 2012 12:47 PM by wimdecorte

    ExecuteSQL ORDER BY?


      The following ExecuteSQL staement provides a list of Restaurants and their respective totals Execellent Taste.

      I would like to reverse the displayed Order to a DESC view by Execellent Taste


      "SELECT b."restaurant_name", sum (a."cnt_ex_taste")

      FROM "ccc" a

      INNER JOIN "restaurant" b ON a."kf_restaurant_id" = b."kp_restaurant_id"

      Group By b."restaurant_name"" ;





      b.restaurant_name sum (a.cnt_ex_taste)

      Catherine Hall 1

      Sovereign 2

      Twin Gates 3


      Any help will be greatly appreciated....