Is this possible in a query?

You have

Table A
Table B

There is a link or join between the two tables. Table A is the main table,
B is a sub or secondary.

When you view the records in datasheet, you see what is there. I want to
see ALL THE OTHER records, the ones that do not meet that requirement, they
do not have any records in table B. So they are being filtered out and I
want to only see those records.

Curtis