Record Matching Software to Compare two tables and match on % Based
- by Crazyd
So I have some table with Name, Address, and Zip with no record data attached; and I have a table which has all the same, but has more information and I need a way to merge the tables when they don't match 100%.
How do I match them up if they aren't Identical? I'm a newb @ SQL, but I know they won't match up for the most part and I can't be the only one with this issue. However software which will do this has proven to be difficult.
Writing software to do this would even be worse than having to do it in the first place.
I know I can do this in excel; kinda, but with the amount of records I have its proving to be difficult over a million.