@jaredbusch thank you.
I posted the SQL at the command line and it returned the same error.

I figured it out though as I seemed to have a Clients group in both the External and Private Contact Manager Areas - hence the return of two records in the subquery.

I deleted the Clients Group from the Private area leaving just the one in the External area, and it started working.