>>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.
I saw it later, I think UNION is easier to understand, but as long as your code works it's all that matters.
If it's not broken, fix it until it is.
My Blog