Re: need some help fast, Please

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 28 Oct 1999 16:38:23 +0200
Message-ID: <7v9n74$c37$1@oceanite.cybercable.fr>

Try:

select sv.name, sv.key_STORE_seqID, SUM(rv.amount) Amount, SUM(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'
GROUP BY sv.name, sv.key_STORE_seqID
;

--
Have a nice day
Michel

Joe D <joed_at_icoms.com> a écrit dans le message : 38185d37_at_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:38:23 CDT