At 22:53 06.09.01, you wrote:
>mysql> SELECT receiver_id, associate_of, user_name FROM receivers;
>+-+--+-+
>| receiver_id | associate_of | user_name |
>+-+--+-+
>| 1 |0 | arnold |
>| 2
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 sele
Hi,
Please help me with a query. I looked in the documentation w/o success.
Consider this table:
mysql> SELECT receiver_id, associate_of, user_name FROM receivers;
+-+--+-+
| receiver_id | associate_of | user_name |
+-+--+---