Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using a sumed column in a select
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using a sumed column in a select
Miscellaneous
Thread ID:
00623132
Message ID:
00623132
Views:
47
Is there a way to do the following? I get a invTotal column not found.
	Select invoice.cCompanyName,  ;
		sum(invoice.yTotal) as invTotal,  ;
		sum(invoice.ySalesTax) as invTax,  ;
		invTotal - invTax as netRev  ;
		from invoice  ;
		group by cCompanyName ;
- or do I have to do -
	Select invoice.cCompanyName,  ;
		sum(invoice.yTotal) as invTotal,  ;
		sum(invoice.ySalesTax) as invTax,  ;
		sum(invoice.yTotal) - sum(invoice.ySalesTax) as netRev  ;</b>
		from invoice  ;
		group by cCompanyName ;
Roi
'MCP' Visual FoxPro

In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!
Next
Reply
Map
View

Click here to load this message in the networking platform