Struggling with a JOIN query

[r937]

whew, well, i’m relieved you’re sorted