Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Logic
Message
 
To
23/05/2002 21:30:59
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Logic
Miscellaneous
Thread ID:
00660852
Message ID:
00660902
Views:
14
Carmen,

>... member who brought the most member join into the club. I open a table which have two column in such as member code and introducer.

This is not tested but try something like this
select INTRODUCER, count(MEMBER) as MembersRecruted;
  from <MyTable>;
   group by INTRODUCER;
    order by 2 desc;
     into cursor SELECTION

browse normal 
The first record will be the one with the most members. If You only want this one
You can also add the top clause
  select Top 1 INTRODUCER ....
HTH
Regards from Berlin

Frank

Dietrich Datentechnik (Berlin)
Softwarekombinat Teltow (Teltow)

Frank.Dietrich@dd-tech.de
DFPUG # 327
Previous
Reply
Map
View

Click here to load this message in the networking platform