Thanks for the response.

Both sub queries refer to elements external to them.

The inner subquery refers to ser which is outside of it.

( SELECT serinner1.SourceServiceId

...