now the scenario is :
the user A is from the company "Alpha"
he introduces user B, who registers in the system his company bcomes "self",
now B inturn refers user C who also registers in the system and his company
is now again "self".
Now I need to generate a report of number of users that have registered
under one company, for eg.
for the company "Alpha" no of users becomes 2 since A refered to two users
and both of them have registered.
I m stuck with the query.
thanks in advance...