Hi There,
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
Can you show your query that is only returning a single record? The solution above should get you pretty close to what you're looking for. The like clause probably should have a wild card, "LIKE 'ARC -%' "