Solution - View of IDs Based on 2 Fields

[ChristianM]

Thought this might help anyone struggling as I did to create a View of only IDs (1) not duplicated between two tables or (2) duplicated between two tables but a second field is a certain value.

I have two tables:

1. Table A - has a list of every available ID

2. Table B - contains IDs of inserted records (can have same ID on multiple records)

I did a full outer join on the two tables in a View based on the ID

First criteria only show IDs that are in Table A but not in Table B

 

I then only want to include IDs if the record is in Table A and Table B, but a second field has a value of "Yes". However, Table B can have multiple records with the same ID with the second field with values of "Yes" or "No". The Not Equal filter wouldn't work because you can't NOT at the AND level.

To solve this I added a sub-AND filter with two lines stipulating what I wanted the field to be and what I wanted it not to be.