Re: help needed

From: Ethan Post <epost1NOepSPAM_at_yahoo.com.invalid>
Date: 2000/07/18
Message-ID: <01fbe0fe.6b2dc6ed@usw-ex0105-037.remarq.com>#1/1

Looks like you need to use an alias for the columns you are aggregating. Like

sum(amount),

it should be

sum(amount) as amount,

this way the program knows the column is called "amount", otherwise it thinks you the column is actually called "sum (amount)" and it doesn't like that.

-Ethan
http://www.freetechnicaltraining.com/oracle_links.htm

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Tue Jul 18 2000 - 00:00:00 CDT