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]