Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Sum
Message
 
To
08/08/1998 21:18:24
Donald Burton
Brierley & Partners
Dallas, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: SQL Sum
Miscellaneous
Thread ID:
00125058
Message ID:
00125340
Views:
19
Hi Donald,

If I understand the problem correctly that you have different "for" requirements for your sums

Try:
Select all , sum(iif( [Lexp] ,x,0)), sum(iif( [Lexp] ,y,0)) from Sample

Dan
Dan Goodwin
Primary Data Solutions
Previous
Reply
Map
View

Click here to load this message in the networking platform