Query Accounts without a certain Account Team Member Role

[Rew]

I’m trying to build a list of accounts that do not have an SDR on the Account Team (AccountTeamMember)

Is there any way to query accounts that do not have a certain account team member role related to it?

I’ve tried a subquery where the TeamMemberRole does not contain ‘SDR’ but it isn’t working as I thought it would.

[Rob_Hatch]

You are on the right track with a subquery condition. You need to filter Accounts where the AccountID is NOT IN the results of the subquery returned from the AccountTeamMember object.

I’ve done a similar thing with opportunities and line items in the example page attached below.

SubQuery_NoChildren.xml (2.8 KB)