>I'm not really sure what you're after . Will this work for you?
>

>SELECT Member.FirstName 
>	FROM Member 
>	WHERE EXISTS (SELECT 1 FROM Friend 
>  		    WHERE Friend.NoMember = Member.NoMember OR Friend.NoMember2 = Member.NoMember)
>		AND Member.NoMember = 1	
>
>

Thanks, the revised version would then be:

SELECT Member.FirstName 
	FROM Member 
	WHERE EXISTS (SELECT 1 FROM Friend 
  		    WHERE Friend.NoMember = Member.Numero OR Friend.NoMember2 = Member.Numero
  		    and (Friend.NoMember=1 or Friend.NoMember2=1))
 AND Member.Numero<>1

where the ID used for the condition would then be the ID of the member I would like to obtain the possible matches in the friend table.