Table-How To Have Seasons In Headers With Prices In Columns??

 Hi,
I would like to change my select to generate table that will results
That will have
Service, Room, Season A, Season B
Where season names are saved in database and in their colums I would like to have pricing for rooms.
How can I accomplish this - I dont know how to clearly explain - hope SQL will help:  String selectCommandBookings = "SELECT dbo.Service.Name AS Service, dbo.Room.Name AS Room, dbo.Season.Name AS Season, dbo.HSRSeason.Price";
selectCommandBookings += " FROM dbo.Season INNER JOIN";
selectCommandBookings += " dbo.HSRSeason ON dbo.Season.SeasonID = dbo.HSRSeason.SeasonID INNER JOIN";
selectCommandBookings += " dbo.HSR ON dbo.HSRSeason.HSRID = dbo.HSR.HSRID INNER JOIN";
selectCommandBookings += " dbo.Room ON dbo.HSR.RoomID = dbo.Room.RoomID INNER JOIN";
selectCommandBookings += " dbo.Service ON dbo.HSR.ServiceID = dbo.Service.ServiceID";
selectCommandBookings += " WHERE (dbo.HSR.HotelID = '" + hotelID + "')";
selectCommandBookings += " ORDER BY dbo.Service.Name, dbo.Room.Name, dbo.HSRSeason.Price";