I've got a SQL query which for love or money i cant seem to get my head around.
The table:

id2    name    id1
--------------------------------------
1       andy    181
2       bob      1
3       Jim      2
4       helen   1

To explain what you are looking at a user with the ID 181 invited "Andy"
Andy with the ID 1 invited bob and helen
And Bob with the ID 2 invited jim.

Hopefully you can see the setup.

What i basically need to do is get a list of ID2 and a count of the
people ID1 invited.

Cheers

Andy
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to