SELECT * FROM RoomType, RoomRate, RateCategory WHERE RoomRate.RoomTypeID = RoomType.RoomTypeID and RoomRate.RateCategoryID = RateCategory.RateCategoryID ORDER BY RateCategory.RateCategory;
#RateCategory#
#RoomType#£ #DecimalFormat(cost)#
#RateDesc#