Select count(Referer) as refcount
From myTable
Where Referer = #myUserID#
Cutter
Dave Phillips wrote:
> Hi guys,
>
> I hope this isn't too far off topic, but I'm stuck on an SQL issue and
> really need some help.
>
> I have a table with these two fields:
>
> UserID (int)
> Referer (int)
>
> UserID is obviously my user's ID number. Referer refers to the UserID
> of the person who referred them.
>
> I need to run an SQL Query that returns to me the total number of
> records in which a UserID is in the Referer.
>
> For example, Ted is UserID 1 and John is UserID 2
>
> Ted Refers, Jan, Jerry and Jack
>
> John Refers Mary and Bill
>
> I now have 7 records, all unique UserID's but the referer for Jan, Jerry
> and Jack is 1 and the referer for Mary and Bill is 2
>
> I want to run an SQL Query that returns the following results:
>
> UserID NumReferred
> 1 3
> 2 2
>
> I know it's GOT to be possible to do it all in SQl. I know I can do it
> in CF with no problem by looping over my userid list, but that takes way
> too long.
>
> Any ideas?
>
> Thanks!
>
> Dave
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
