I have a querry that I would like to condense to not as many rows... it is attached to the below database.
The end result is I would like it to condense all same BookingID's to one row. For instance, in bookingID 79 all columns are the same except for the last two columns. I would like the new querry to compbine those two columns to one row titled: "Description". That "description" column would combine all the DateAppintments with the appropriate Duration
The end result for BookingID 79 would be one row that looks like this:
BookingID customerID StartDate TutorName TotalPrice StudentName Description
79 AnsevinChris 2/14/2011 Teve 200 Name 2/17/2011 for 1 Hour, 2/18 for 1 Hour, 2/19/2011 for 1 Hour, 2/20/2011 for 2 Hour
Does this make any sense? I hope so, it would be awesome if it works!