How can I find unmatched records across 2 fields

[Guest]

I have 2 tables that have the following fields 1) Docket Number 2) item. I
need to find instances in either table when the Docket Number together with
the Item do not match. I have tried joining the 2 fields with & " " & and
doing an unmatched query but this doesn't work

 

[Brendan Reynolds]

You can join on multiple fields ...

SELECT Table2.*
FROM Table2 LEFT JOIN Table1 ON (Table2.item = Table1.item) AND
(Table2.docketnumber = Table1.docketnumber)
WHERE (((Table1.ID) Is Null));

.... where 'ID' is the primary key.