Re: Developing Query
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Fri, 21 May 2010 17:06:24 +0200
Message-ID: <4bf6a16c$0$22942$e4fe514c_at_news.xs4all.nl>
Op 19-5-2010 17:50, Don B schreef:
> select INQMSIS.mine_tbl.sic_desc, COUNT
> (INQPROD.ACC_INJ_TBL.AI_DOC_NUM), COUNT
> (INQPROD.ACC_INJ_TBL.AI_DOC_NUM) * 200000 from INQPROD.ACC_INJ_TBL,
> INQMSIS.mine_tbl where ((INQMSIS.mine_tbl.c_m_ind = 'M') and
> (INQPROD.ACC_INJ_TBL.INJ_DEGR_CD IN ('01', '02', '03', '04', '05',
> '06')) and ((to_number(to_char(INQPROD.ACC_INJ_TBL.AI_DT,'YYYY' ))) =
> 2009)) and INQPROD.ACC_INJ_TBL.MINE_ID = INQMSIS.mine_tbl.mine_id
> group by INQMSIS.mine_tbl.sic_desc order by 1 ;
>
Date: Fri, 21 May 2010 17:06:24 +0200
Message-ID: <4bf6a16c$0$22942$e4fe514c_at_news.xs4all.nl>
Op 19-5-2010 17:50, Don B schreef:
> select INQMSIS.mine_tbl.sic_desc, COUNT
> (INQPROD.ACC_INJ_TBL.AI_DOC_NUM), COUNT
> (INQPROD.ACC_INJ_TBL.AI_DOC_NUM) * 200000 from INQPROD.ACC_INJ_TBL,
> INQMSIS.mine_tbl where ((INQMSIS.mine_tbl.c_m_ind = 'M') and
> (INQPROD.ACC_INJ_TBL.INJ_DEGR_CD IN ('01', '02', '03', '04', '05',
> '06')) and ((to_number(to_char(INQPROD.ACC_INJ_TBL.AI_DT,'YYYY' ))) =
> 2009)) and INQPROD.ACC_INJ_TBL.MINE_ID = INQMSIS.mine_tbl.mine_id
> group by INQMSIS.mine_tbl.sic_desc order by 1 ;
>
Try something like this:
select sic_desc, mycount, 200000 * mycount myproduct from ( select INQMSIS.mine_tbl.sic_desc, COUNT
(INQPROD.ACC_INJ_TBL.AI_DOC_NUM) mycount from INQPROD.ACC_INJ_TBL, INQMSIS.mine_tbl where ((INQMSIS.mine_tbl.c_m_ind = 'M') and (INQPROD.ACC_INJ_TBL.INJ_DEGR_CD IN ('01', '02', '03', '04', '05','06')) and ((to_number(to_char(INQPROD.ACC_INJ_TBL.AI_DT,'YYYY' ))) = 2009)) and INQPROD.ACC_INJ_TBL.MINE_ID = INQMSIS.mine_tbl.mine_id group by INQMSIS.mine_tbl.sic_desc) order by 1 ;
Shakespeare Received on Fri May 21 2010 - 10:06:24 CDT