1 Reply Latest reply: Jan 12, 2018 8:53 AM by Sunny Talwar RSS

    Not getting proper result, please hle

    Sandeep sharma

      Hi Guys,

       

      I have two tables .

         

      TABLE A
      CODENEED_DATEA
      A12-Mar-182
      B12-Mar-181
      B12-Mar-183

       

         

      TABLE B
      CODEDELIVERY_DATEB
      A02-Mar-1810
      B07-Jan-185
      D18-Jul-188

       

      in both tables CODE is the common attribute.

      Based on condition where DELIVERY_DATE <= NEED_DATE, I want below result .



         

      NEED_DATESUM OF ASUM OF B
      12-Mar-18615

       

      Please help .

       

      Thanks

      Sandeep