You should be able to join the tables like this:
select p1.id /* and other cols */
from people1 p1
inner join people2 p2 on p1.Lname = p2.Lname and left(p1.Fname, 3) =
left(p2.Fname, 3)
group by p1.id;
HTH, James Harvard
>I have two independently built tables of people. I am trying to match pe
I have two independently built tables of people. I am trying to match
people from one with people from the other. The problem is that in one
table they may have used "Ron" and in the other "Ronald". What I want
to do is have a match if on something like "if 'Ronald" is like 'Ron%'
but obvio
