Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SUM function
Message
From
05/11/2002 15:24:59
Welington Lourenço Melo
Consultor Independente
Belo Horizonte, Brazil
 
 
To
05/11/2002 12:31:01
Alvin Lourdes
Children and Youth Services Cluster
Toronto, Ontario, Canada
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: SUM function
Miscellaneous
Thread ID:
00718969
Message ID:
00719038
Views:
16
Hi, 
SELECT SUM(ISNULL((a.Price * x.Factor) - Discount /100,(b.Price * x.Factor) - Discount / 100))) FROM TABLEA a, TABLEB b, TABLEX x
You need include FROM clause
Atenciosamente,
Welington Lourenço Melo de Paula BH / MG
welingtonl@yahoo.com.br
Previous
Reply
Map
View

Click here to load this message in the networking platform