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

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