Query multiple fields for an exact match of record 1

[LowBrow]

I have two tables:
TableA is a master list of names, addresses, phone numbers, etc. TableB is a volunteer list. I need to write a query such that:
From TableA select specific row where lastname, firstname, mailadd = specific row from TableB.
TableB contains inaccurate information and I need to compare parts of each record to the records in TableA to pull out possible corrected information. I hope this makes sense. Here is an example:
In TableA there would be a perfect record that had
LstName FstName StAdd City State
Doe John 1234 Eastwood St New York NY

In TableB I may have a record that has:
LstName FstName StAdd City State
Doe John New York NY

In this case, I would have my query search for a distinct record that had From Table:LstName, FrstName, City, State
= TableB LstName, FstName, City, State

I'm sure there has to be a way to write this query. If anyone has any ideas, please let me know.
Thanks!

 

[r937]

[tt]select A.LstName
, A.FstName
, A.StAdd
, A.City
, A.State
, B.LstName
, B.FstName
, B.StAdd
, B.City
, B.State
from TableA A
inner
join TableB B
on A.LstName = B.LstName
and A.FstName = B.FstName
and A.City = B.City
and A.State = B.State [/tt]

rudy

http://r937.com/

SQL Consulting

 

[LowBrow]

Thank you very, very much! I thought I had tried this, but it kept returning matches of All last names, all first names, etc. (as though I had used OR instead of And). But this works perfectly! Thanks again!