Robert,

I think your right my best option is to write two queries

One to join to provider and one to join for member depending on the EntityType.

If EntityType = 1

Begin

--Join...