Greg

ExecuteSQL ORDER BY?

Discussion created by Greg on Jul 13, 2012
Latest reply on Jul 13, 2012 by wimdecorte

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

Outcomes