Re: I need some help with this query

Thanks, I'll give it a try. :)

Joe

Otto von Stirlitz <ivg_at_beer.com> wrote in message news:381dc124_at_athene.hdm-stuttgart.de...
> >select sv.name, rv.store_id, sum(amount + freight) Total from
> >report_stores_view sv, REPORT_TRANSACTION_VIEW rv
> >where TRANSACTION_DATE >= 936158400 and TRANSACTION_DATE <= 938664000
> >and transaction_type != '3'
>
> and sv.store_id = rv.store_id
>
> >and rv.STORE_ID =
> >(select store_id from STORE SS where SS.KEY_STORE_SEQID =
> >(select V.KEY_STORE_SEQID from REPORT_STORES_VIEW V where NAME =
> >'store_xyz'))
> >group by name, rv.store_id;
>
>
Received on Mon Nov 01 1999 - 11:39:21 CST