Developing Query

From: Don B <Braenovich.Don_at_DOL.GOV>
Date: Wed, 19 May 2010 08:50:20 -0700 (PDT)
Message-ID: <139593f4-44ac-428e-b234-4fbb579f3be6_at_c11g2000vbe.googlegroups.com>

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 ;

I am trying to modify a query to show an additional column. This column is suppose to multiply the Count Document No. column by 200,000. I am a beginner and cannot figure out what I'm doing wrong. Can somebody get me on the right path.

Thanks
Don Received on Wed May 19 2010 - 10:50:20 CDT