SELECT id
FROM team_members
WHERE NOT
EXISTS (
SELECT *
FROM team_members_functions
WHERE team_members.id = team_members_functions.team_member
)