I have been asked by a friend to help find some rogue records.
There are 2 tables and I need to find records in Table1 that should not be there.
In Table1 the description field of the records I am interested in always begins with "ARC - " and I want to find all the records in Table1 that have the description that begins with "ARC - " and Table1.Autoid is not in the Table2 field ARCId
Does that make sense?
I have tried but I keep getting records returned that are correct and should be there.
In essence what I need is to show all records from Table1 that have a description beginning with "ARC - " and it's AutoId can not be found in Table2
Thanks for your help.