| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: I need some help with this query
>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 - 10:36:54 CST
 |
 |