queries

  • Thread starter Thread starter Gregory Debosschere
  • Start date Start date
G

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? If you know that I start with a
tblParticipers:
NameId Name
1 Hayley
2 Craig

and a tblOrganisationWorkshop:

ParticipersId Uur Workshop
1 14 Java
1 15 Safety
1 16 Router
2 14 Safety
2 15 Java
....
Thanks
 
Gregory Debosschere said:
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?
Click to expand...

TRANSFORM First(O.Workshop)
SELECT P.Name
FROM tblParticipers AS P
INNER JOIN tblOrganisationWorkshop AS O ON P.NameID = O.ParticipersID
GROUP BY P.Name
PIVOT O.Uur;
 
Back
Top