yet another argument for sub-selects :)
Paul DuBois wrote:
>
> At 2:31 PM -0800 3/22/01, Daren Cotter wrote:
> >I have a table, which keeps track of member information (including which
> >member referred the member). To get a count of the # of referrals for member
> >25, my query is:
> >
> >SE
uBois [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 22, 2001 12:58 PM
To: Daren Cotter; [EMAIL PROTECTED]
Subject: Re: Referer Count
At 2:31 PM -0800 3/22/01, Daren Cotter wrote:
>I have a table, which keeps track of member information (including which
>member referred the member).
At 2:31 PM -0800 3/22/01, Daren Cotter wrote:
>I have a table, which keeps track of member information (including which
>member referred the member). To get a count of the # of referrals for member
>25, my query is:
>
>SELECT COUNT(*) FROM members WHERE ref1 = 25;
>
>To get a list of the top refer
his is not ANSI sql, so it
might be best to avoid this mysql-specific behavior.
braxton
-Original Message-
From: Daren Cotter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 5:31 PM
To: [EMAIL PROTECTED]
Subject: Referer Count
I have a table, which keeps track of mem
I have a table, which keeps track of member information (including which
member referred the member). To get a count of the # of referrals for member
25, my query is:
SELECT COUNT(*) FROM members WHERE ref1 = 25;
To get a list of the top referers and the # of referrals they have, my query
is:
S
