I am working on query to determine if there are missing records in one table, by comparing two tables. Here is a simple example of this below. I am having an issue with it not distiguishing finding any records verses needing all of them to be present to get a "Yes" result..
Table 1 – Team and Members
Team Member
Blue Becky
Blue Tom
Blue George
Red Sam
Red Mike
Table 2 - Members
Member
Becky
Tom
George
Sam
Statement results should return Team name with a Yes - If all members exist in Table 2 that are present in tables one, No - If not all members from Table 1 exist in Table 2
In the example above the results would be:
Team All_Members_Present
Blue Yes
Red No