In need of your help please.
I have 2 tables, Table1 & Table2
I would like to search Table1 and for every record I find with a status = 9 use Table1.RecId to match a record in Table2 and when a match is found delete the record in Table2
Could you help me with how I would go about that.
I appreciate your help.