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
INNERJOIN Friend ON
(Friend.NoMember = Member.Numero AND Friend.NoMember2=1) OR
(Friend.NoMember = 1AND Friend.NoMember2=Member.Numero)
WHERE Member.Numero<>1