>I guess Sergey already answered it, but I would answer anyway, since this is the question I answered just a day ago on another forum too (I haven't yet checked other answers in this thread). You need to use UNION here, e.g.
>
>select Member.FirstName from Friend INNER JOIN Member ON ?
>UNION ;
If you see my other reply, I used the INNER JOIN without UNION to address the issue.