Best way to match address from two tables

  • Tannu4u
  • Proficient
  • Proficient
  • User avatar
  • Posts: 480
  • Loc: India

Post 3+ Months Ago

Hi gyus,

I am having a weird situation where i have to match address fields from one table with the address fields in the second tables.

Let me explain a bit:-
- I am having two tables users and sites
- both the tables have division, department, address1, address2, city, state, country fields

Now what i want to do is write a query where i can get the matching records from the two tables, the address need not match exactly.

Both the tables are having around 1,000,000 records.

Thanks in advance
Amit
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • BIOSTALL
  • Graduate
  • Graduate
  • User avatar
  • Posts: 125
  • Loc: UK

Post 3+ Months Ago

Quote:
Now what i want to do is write a query where i can get the matching records from the two tables, the address need not match exactly.


How can you get the matching records if the addresses need not match exactly? Do they match or don't they :lol:
  • Tannu4u
  • Proficient
  • Proficient
  • User avatar
  • Posts: 480
  • Loc: India

Post 3+ Months Ago

What i ment there was that i have fields (division, department, address1, address2, city, state, country) and its not necessary that every column match.

It could be like country, city and state match but not the other fields.

This is a fuzzy matching job but i am having problem getting this.
  • Tannu4u
  • Proficient
  • Proficient
  • User avatar
  • Posts: 480
  • Loc: India

Post 3+ Months Ago

I have got one solution its not 100% exact match but its based on a fuzzy match of the addresses.

Post Information

  • Total Posts in this topic: 4 posts
  • Users browsing this forum: No registered users and 134 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.