(I originally added this to an older thread, but it is really a new question, so here it is...)
Just when I thought I'd got the hang of this eSQL thing ... I now have a new problem with a join query, which I've really tried to figure out, but to no avail.
The relationships are between Sessions (SSN), Programmes (PGM), and Programme Titles (PTI) - i.e. SSN -> PGM -> PTI.
For a group of Sessions, I want to show the number of Sessions for each Programme Title.
Here's the eSQL that I've come up with, based on advice from people here. (And I'm sorry, Beverly, I haven't renamed my primary keys, yet...).
It works, "kind of". The problem with it is that the result is doubling the number of Sessions within each Programme Title - in the example below, the results should be Crusoe Club 4, Forget-Me-Not 3, Sunday Club 3, etc.
Any idea what I'm doing wrong?