With this query approach how do you find people that have a prop1 but do not a prop2? If you get records back with prop1 then you have to remove those records

With this query approach how do you find people that have a prop1 but do not a prop2? If you get records back with prop1 then you have to remove those records from results based on another record. There are multiple ways to accomplish this but it can't be done with a single join and simple where clause.