Excellent class so far, however my problem does not seem to fit.  I have a many to many relationship between people and groups with a junction table.  I want to find out who is in group A, who is in Group B and who is in both Group A and Group B.  I thought it might come up here with the logical functions but it does not.  Where do I look for an answer?

---

Reply from Alex Hedley:

A WHERE clause is first covered in Expert 3
You could create 3 separate queries each with a different WHERE clause
You could use a UNION query to get A and B.