Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL Help

SQL Help

From: Paul Davies <cobalt_at_dircon.co.uk>
Date: Fri, 7 May 1999 10:41:50 +0100
Message-ID: <3732b536@newsread3.dircon.co.uk> 





If I have a function that used an aggregate query:



select sum(VAL), VAL1



from TABLE1,TABLE2 where..



but there only one row of VAL1 will be returned because of the join, how can
I write this query so Oracle does not keep giving me an error because of the
combination of the aggregate function and VAL1?



Help appreciated



Paul


Received on Fri May 07 1999 - 04:41:50 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US