Access Query for Sibling Class Pairs
Budget: $10 – $30 USD
I need a single SQL statement that I can paste straight into Microsoft Access to uncover every pair of classes that share siblings across them. In my data:
• Student, Class and StudentClass are the only tables involved.
• Sibling relationships are defined by a matching parents email address stored on each Student record.
• The required result set is one row per class pair, plus a concatenated list of the sibling names in that pair, matching the pattern:
ClassA – ClassB
Joe Smith, Jenny Smith
Tom Toad, Terry Toad
Deliverable
– A ready-to-run SELECT query in Access SQL that produces the above output.
– A brief comment block explaining any joins, GROUP BY logic or string-aggregation technique you use so I can adjust it later if table names change.
• Student, Class and StudentClass are the only tables involved.
• Sibling relationships are defined by a matching parents email address stored on each Student record.
• The required result set is one row per class pair, plus a concatenated list of the sibling names in that pair, matching the pattern:
ClassA – ClassB
Joe Smith, Jenny Smith
Tom Toad, Terry Toad
Deliverable
– A ready-to-run SELECT query in Access SQL that produces the above output.
– A brief comment block explaining any joins, GROUP BY logic or string-aggregation technique you use so I can adjust it later if table names change.