>As a revised version, in order to collect fields from the joined table, I an now using this:
>
>

>seLECT 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
>

I don't see here you're using EXISTS as Sergey suggested originally. However, this SQL in the same as

SELECT Member.FirstName ,Member.LastName,Friend.ModDate,Friend.Approve
	FROM Member 
	INNER JOIN Friend ON
	Friend.NoMember = Member.Numero AND Friend.NoMember2=1
WHERE Member.Numero<>1 
UNION
SELECT Member.FirstName ,Member.LastName,Friend.ModDate,Friend.Approve
	FROM Member 
	INNER JOIN Friend ON
	Friend.NoMember = 1 AND Friend.NoMember2=Member.Numero
WHERE Member.Numero<>1

BTW, once one person approved being a friend, he/she can not initiate a request to the other person, correct?

In other words, one person made a request to become a friend, the other accepts and this began their friendship?