Balazs Szemes wrote:
> Hi,
> It is a recursive table design, meaning that a person can have a boss. The
> boss' id is stored in the associate_of column. Eg. elmer is barney's
> associate, barney is boss of elmer, and diana
>
> Let's say I only know the user_name 'barney', and I would like to select
> all his associates.
>
> I tried a subquery, as it was most logical:
As you found out MySQL does not support subqueries.
>
> Any help is appreciated. Also, if someone could point me to the right
> section in the on-line doc. I did not find stuff on operator precedence or
> more than one '=' signs in the same expression.
You need to do it in code (C/C++/Perl/Python/Cobal/etc., er....
C++/C/Python/Perl/Cobal/etc.).
AFAIK you cannot have more than one equals sign in a statement in MySQL.
--Bill
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
