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

    ExecuteSQL ORDER BY?

    Greg

      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"" ;

       

       

      Results:

       

      b.restaurant_name sum (a.cnt_ex_taste)

      Catherine Hall 1

      Sovereign 2

      Twin Gates 3

       

      Any help will be greatly appreciated....

       

      greg