Query's

[Gregory Debosschere]

Hello, I have a little question. I organise a workshop with 3 activities and
now I want to make a query so I can see who does what activitie at what
hour.

So for exemple:
Name 14H 15H 16H
Hayley Java Router Safety
Craig Router Java Safety

How can I do this with a query?
Thanks

 

[Stephen Russell]

Hello, I have a little question. I organise a workshop with 3 activities
and now I want to make a query so I can see who does what activitie at
what hour.

So for exemple:
Name 14H 15H 16H
Hayley Java Router Safety
Craig Router Java Safety

How can I do this with a query?

Normalization query is what you need.

Select name, '14H' as hr, 14H as Activity
from YourTable
union
now repeat the query and change the 14 to the next #,15,16,... as needed.

last one gets the order by clause.