On Wed, 23 Jul 2003, Sam Tregar wrote:

>   SELECT a2.name 
>   FROM alpha AS a1, bravo AS b, alpha AS a2
>   WHERE a1.name = 'fred'  AND
>         a1.id   = b.afrom AND
>         b.ato   = b.id;

Whoops, that last line should read:

          b.ato   = a2.id;

-sam


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to