SQLTeam.com | Weblogs | Forums

Matching data


#1

I have a file with the following data:
3 Withingham Road Branksome Park Poole 3 Withingham Road Branksome Park Poole
7 Wilderton Road Branksome Park Poole 7 Wilderton Road Branksome Park Poole
7a Wilderton Road Branksome Park Poole 7a Wilderton Road Branksome Park Poole
13 Wilderton Road Branksome Park Poole 13 Wilderton Road Branksome Park Poole
5 Canford Cliffs Road Canford Cliffs Poole 5 Canford Cliffs Road Canford Cliffs Poole

Is there an easy way to see if the data in the above table matches with data from 1 field in another table ?


#2

Hi

Do you want row by row comparison?


#3

Hi, ideally that would be what I am looking for.