Hi all
Got a table that looks like this:
I want to output three columns:
I can do this for individual days and this is what I have at the moment is:
How do I get the output to show each day next to each other?
Got a table that looks like this:
Code:
Timeofbooking Dayofbooking Name
09:00 Tue Paul
09:00 Thur Steve
09:30 Tue Phil
10:00 Thur Sally
10:15 Tue Jim
10:15 Tue Bob
10:15 Thur Mark
...I want to output three columns:
Code:
Time Tue Thur
09:00 1 1
09:30 1 0
10:00 0 1
10:15 2 1
...I can do this for individual days and this is what I have at the moment is:
Code:
select timeofbooking, count(timeofbooking) from bookingstable
where studentref <> 'NOT AVAILABLE - DO NOT CHANGE' and dayofbooking ='tue'
group by timeofbooking
order by timeofbookingHow do I get the output to show each day next to each other?