• I totally missed that spurious semicolon in the subquery.

    I was focused on the logic of the statement, and not a spurious typo.

    Good to hear someone put what I felt here into words.

    Jamie