2 Replies Latest reply: Jul 15, 2015 9:50 AM by Piet Hein van der Stigchel RSS

    Max Month

      Hi

         Table1:

      DateMAR
      2015-03-19ABC124
      2015-02-20ABC34
      2015-03-21ABC5656

         

      Table2:

         

      Att_DateLogTypeDuration
      2015-03-19Present450
      2015-02-20Present621
      2015-04-21Present458
      2015-03-20Present420

      Based on Max Month available in Table 1 , Duration in Table 2 to be summed up and shown up for the same month ,

       

      In the above ex : Duration of March to be summed up