I have a table tblA with emplid, joindt and jointm and department.
I have another table TblB with emplid, joindt and jointm and department.
tblA has 4 rows with same emplid and differnt join date+jointm and tblB has 3 rows with same info.
How can I write a query in access to check which row is missing from from TblB
I tried below statement but not getting anything
select * from tblA where notexists (select joindate+jointm from tblB where tblA.emplid=tblB.emplid )
Thanks,
Blyzzard