Find records not in another table OR are in the table with a specific field value

[mrfourpointo]

In Table A, I have many fields that I am pulling into a query, some with criteria. One of my fields is Last_Name. I would like my query to include all records that are in Table A and not in Table B AND all records that are also in Table B, but have a certain value for a field in Table B.

Table A

Last_Name

Lincoln

Washington

Clinton

Bush

Table B
Last_Name	Category
Lincoln	A
Washington	B
Clinton
Bush

I would like my query to return Clinton and Bush because they are not in Table B, but also Lincoln because it is category "A".

[Gicu]

Hi there,
see the union query qrySHOW_A_NOT_B_AND_B_CAT_A in the attached database.

Cheers,
Vlad