I don't know enough about your data but it seems possible to me that different friends can refer to the same member and you did not include any column from the Friend table that identifies from which friend the rest of columns are coming..
>As a revised version, in order to collect fields from the joined table, I an now using this:
>
>
>SELECT DISINCT Member.FirstName ,Member.LastName,Friend.ModDate,Friend.Approve
> FROM Member
> INNER JOIN Friend ON
> (Friend.NoMember = Member.Numero AND Friend.NoMember2=1) OR
> (Friend.NoMember = 1 AND Friend.NoMember2=Member.Numero)
>WHERE Member.Numero<>1
>
--sb--