5 Replies Latest reply: May 16, 2018 8:45 AM by Bharat Kishore RSS

    where clause issue

    Bharat Kishore

      Hi All,

       

      i have the below code:

       

      LOAD Plant,

           Part_Type,

           Contract_Type,

           BUEqui,

           Country,

           Strategic_Flag,

           YearMonth,

           Fiscal_Month,

           Calendar_Year,

           ITM_Consumption,

           ITM_IB,

           YTD_Consumption,

           YTD_IB,

           YTD_Consumption_LY,

           YTD_IB_LY,

           ADJ_CONS_YTD_LY,

           Country_CR,

           Country_Final_temp,

           Country_Final

      FROM

      [\..\T1.qvd]

      (qvd) where YearMonth = '201712';

       

      when i give this where clause i am getting 0 records and when i remove the where condition i am getting the output..

       

      Can you please tell me where  i am doing wrong..

       

      Thanks,

      Bharat