Training event query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a junction table that has customer ID numbers in one column and class
ID numbers in the other. Customers may be enrolled in anywhere from 1 to 19
classes in our training event. How do I create a query that will identify
all the customers enrolled in course 1 AND in course #, for example. Or all
customers that have decided to take courses 5, 6 and 8?
 
I have a course scheduling calendar module which displays the schedule of
courses for each day on a calendar. You can select and month in any year.
You can add/edit/delete courses directly on the calendar. You can print out
the calendar. If you are interested in having me implement the course
scheduling calendar module into your database, contact me at my email
address below and I will send you a screen shot.
 
Graeme said:
I have a junction table that has customer ID numbers in one column and class
ID numbers in the other. Customers may be enrolled in anywhere from 1 to 19
classes in our training event. How do I create a query that will identify
all the customers enrolled in course 1 AND in course #, for example. Or all
customers that have decided to take courses 5, 6 and 8?
Click to expand...


Graeme,

Making some assumptions:

Untested:


SELECT CC1.customers
FROM CustomerClasses AS CC1
WHERE (CC1.course = 1
AND CC1.course = 10)

SELECT CC1.customers
FROM CustomerClasses AS CC1
WHERE (CC1.course = 5
AND CC1.course = 6
AND CC1.course = 8)

Sincerely,

Chris O.
 
Back
Top