chineloogbonna
Registered User.
- Local time
- Today, 04:29
- Joined
- Jul 30, 2018
- Messages
- 65
Afternoon,
I've been trying to figure this out for days. I feel like its simple but I just can't get it.
I have two tables, lets say Table1 and Table2.
I am trying to delete duplicate records in Table 2 that are already in Table1. My query, "query1" finds the duplicate records with joined tables but I cannot figure out how to delete the records(s) from Table2 based on the query?
Thanks in advance for any help you can provide!
I've been trying to figure this out for days. I feel like its simple but I just can't get it.
I have two tables, lets say Table1 and Table2.
I am trying to delete duplicate records in Table 2 that are already in Table1. My query, "query1" finds the duplicate records with joined tables but I cannot figure out how to delete the records(s) from Table2 based on the query?
Thanks in advance for any help you can provide!