Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Russell Hill
  Where is Russell Hill?
 Sydney
 Australia
 Russell Hill
 To: Vladimir Zhuravlev
  Where is Vladimir Zhuravlev?
 Medvezhie ozera, Schelkovskiy raion
 Russia
 Vladimir Zhuravlev
 Tags
Subject: RE: SQL SELECT
Thread ID: 143350 Message ID: 143355 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Tuesday, August 28, 2007 7:26:58 AM         
   


>
SELECT OOM, COUNT(*), sum(iif(OOM = 1 and VALUE = 1,1,0)) as CONDCOUNT ;
>   FROM MyTable ;
>   GROUP BY OOM

>
>
>
>
>
>
>
>
> MVP , www.foxclub.ru domain owner
> 100 friends are better than 100 dollars.

Thanks Vladimir.

ENTIRE THREAD

SQL SELECT Posted by Russell Hill @ 8/28/2007 6:51:10 AM
RE: SQL SELECT Posted by Vladimir Zhuravlev @ 8/28/2007 6:54:46 AM
RE: SQL SELECT Posted by Russell Hill @ 8/28/2007 7:26:58 AM