Re: join question

On Wed, 27 Nov 2002 09:37:07 -0800, Nathan Young <nyoung@asis.com>
wrote:
>OK, that works great, but I was told that I should avoid sub-selects when 
>possible for performance reasons.
>>
>> select member.memberId, member.name from member left outer join
>>  (select * from payment where yearPaid=2002) as a using (memberId) where
>>  yearPaid is null;

Nathan,
if you want a version without a subselect, try
   SELECT m.memberId, m.name   FROM member AS m LEFT OUTER JOIN        payment AS p ON p.yearPaid=2002 AND
m.memberId=p.memberId  WHERE p.memberId IS NULL;
 

though I don't know whether it is faster.

ServusManfred