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.
Laundry Room - (East) Tuesday 00:00:00 06:00:00
Laundry Room - (East) Wednesday 00:00:00 06:00:00
Utility Room - (East) Thursday 00:00:00 06:00:00
Utility Room - (East) Friday 00:00:00 06:00:00
Gym - (East) Saturday 00:00:00 06:00:00
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.
Laundry Room East
Tuesday 00:00:00 06:00:00
Wednesday 00:00:00 06:00:00
Thursday 00:00:00 06:00:00
Friday 00:00:00 06:00:00
Saturday 00:00:00 06:00:00
Sunday 00:00:00 06:00:00
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?