Check the oracle & advise me

[krishdw85]

Actualy Below SQL posted by myself .
Actually in this site_cd & tot_amt these r the columns prsented in base common data only ,in non vehicle billing data site_cs & Tot_amt columns r not there.

SELECT   BA_CHG_TO_SITE_CD SC, SUM (BA_INV_TOT_AMT * -1) TOTAL
                FROM   MXGFLVB1.BASE_COMMON_DATA T1,
                       MXGFLVB1.BASE_NON_VEHICLE_BILLING_DATA T4
               WHERE       T1.BA_REC_SOURCE = T4.BA_REC_SOURCE
                       AND T1.BA_REC_TYPE = T4.BA_REC_TYPE
                       AND T1.BA_POINT_OF_SALE = T4.BA_POINT_OF_SALE
                       AND T1.BA_SEQ_NO = T4.BA_SEQ_NO
                       AND T1.BA_PRCS_TYP_CD = T4.BA_PRCS_TYP_CD
                       AND T1.BA_PRCS_TYP_CD = 'TR'
                       AND T1.BA_CURR_FING_TRMS_CD = 'X'
                       AND BA_BUSN_DATE >= '2009-11-01'
                       AND BA_BUSN_DATE <= '2009-11-13'
                       AND BA_CHG_TO_SITE_CD BETWEEN '01100' AND '09944'
            GROUP BY   BA_CHG_TO_SITE_CD

Pls Suggest me how 2 start the procedure

[blom0344]

Krish,

This is a Cognos forum ..
Also please do post identical questions in multiple sections. Pick the one that fits best..

Apart from the above.. What is it that you want to do? And procedure are you refering to?

[krishdw85]

Sorry!

I done this report its working