I have a really messy database that I need cleaned up. Our last programmer didn't know what he was doing and messed up a lot of things. First, we have 5 tables in the one database. They were all to contain a unique customer ID, but it was overwrote and lost so we need to start all over again. Each table contains different types of data of customers, approx 15,000 of them... However, we do have one unique field and that is the phone number (all formatted the same in each table = (xxx) xxx xxxx ). What I need done is the unique customer ID's we have set in the first (main) table to be set into the other records of each of the 4 other tables cross referenced by phone number. Second, I need a list of phone numbers that do not appear in the first (main) table. Lastly, because this is customer data, we can not grant you direct access into MySQL or the clients server. Rather I can send over samples with a few rows from each table and for you to write a script or code to do this. Please PM me and include timeline and your price for this.