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 -> need some help fast, Please

need some help fast, Please

From: Joe D <joed_at_icoms.com>
Date: Thu, 28 Oct 1999 10:27:58 -0400
Message-ID: <38185d37@News.Destek.net> 





I have this query:



select  sv.name,  sv.key_STORE_seqID, rv.amount Amount, rv.freight Shipping
from


report_stores_view sv, REPORT_TRANSACTION_VIEW rv
where rv.TRANSACTION_DATE >= 936158400 and rv.TRANSACTION_DATE <= 938664000
and transaction_type = '1'


and sv.key_STORE_seqID = '500080'


;



(I know I have mixed case here but that's not my problem)



What I need to do is to 'sum' the two rv.amount & rv.freight fields. But, I
can't get the syntax right. Can anyone help me please?



TIA


Joe


Received on Thu Oct 28 1999 - 09:27:58 CDT












Original text of this message













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