(probably) very simply SQL query needed : Having a slow day....could use some assistance writing an SQL query. 

I have a list of individuals within families (first and last names), and a second table which lists a subset of those individuals. I would like to create a third table which flags every individual within a family if ANY of the individuals are not listed in the second table. The goal is essentially to flag "incomplete" families. 

Below is an example of the two input tables, and the desired third table. 

[Example of problem][1]

As I said...very simple...having a slow day. Thanks!


  [1]: https://i.stack.imgur.com/oyues.png