Hello all,

I have an issue that I can't solve. I was using SELECT DISTINCT but I think there may be a better way of doing this. Below is some of my sample data.
This data comes from 4 different tables. After joining them all together, I would like to sort the data by the first field which indicates the room type then have all of the times and days under that. As you can see, I have "Laundry Room" 2x. Here is what I am trying to achive.

EDIT: I forgot to mention that that first field (Gym, Laundry room) is data within the field that can be added by the user dynamically. If that data was always the same and never changed, it would be easy. I could just specify exactly what I needed through a select. I hope I am making sense here.

Can someone please point me in the direction I should go with this?

Thanks,

Frank

do this with your application script

it requires merely ORDER BY, not GROUP BY

GROUP BY is for collapsing multiple rows of a group into one result row

Ok Rudy, thanks. I figured that it may need to be done in my application but I was hoping for an sql fix. Thanks again.