Delete Duplicates From All Tables?
I have 4 tables within the same database. All of them have a field called 'email' in them. How do i go about doing a Query which will Delete the row of data if the same 'email' is found in another Table leaving just the 1 record? I dont know if this makes it any easier for you but each row of data has an ID number (note it wont be the same ID number in the other tables for the same 'email' row, its just an Auto Increment i added before importing the data).
Another thing i need to make you aware of is that theres nearly 10 million records between the 4 tables. Is there anything i should do to speed the process up?
If anyone could help me that would be great.