Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help forming field value
Message
From
01/03/2000 15:34:05
Michael Dougherty
Progressive Business Publications
Malvern, Pennsylvania, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Help forming field value
Miscellaneous
Thread ID:
00340063
Message ID:
00340063
Views:
54
sum(a.tvol)-NVL(sum(b.totcxlvol),000) as tvoladj;
or
NVL(sum(a.tvol)-sum(b.totcxlvol),sum(a.tvol) ) as tvoladj;

Which syntax is better?

I was wondering if the duplicate occurance of "sum(a.tvol)" was a performance killer.
Next
Reply
Map
View

Click here to load this message in the networking platform