some more info on this:
putting "user AS friend" improves the query, but does not eliminate the problem.
also, here are the version numbers for each sql server:
mysql Ver 12.22 Distrib 4.0.22, for portbld-freebsd4.9 (i386)
mysql.exe Ver 14.12 Distrib 5.0.24, for Win32 (ia32)
the query even r
> hi
>
> i am experimenting with sql for getting lists of friends.
>
> select friend.*
> from user
>left join link on user.id=link.id and user.id = $MYID
>right join user friend on link.friend_id = friend.id
> where user.name is null;
>
> on my local windows machine running mysql 5
