1 Reply Latest reply: Aug 30, 2011 8:30 AM by rohit gupta RSS

    Join by dates

      Hi,

       

      I want to join tables

      on table have costNamber, cost and date_of_updatd

      and the oter have costNamber and date_of_debit,

       

      of cuorse the cost shuold be attached to the cost of the date that in between the date_of_updatdes

       

      how to do it when ther is one field of date?

       

      is it better to do so in a script or in the object?

       

      Thank you,

      Ester

        • Join by dates
          rohit gupta

          tab1:

          load

          costNamber as costNamber_tab1,

          cost ,

          date((date_of_updatd),'DD/MM/YYYY')  as common_date

          ;

          tab2:

          load

          costNamber as costNamber_tab2,

          date( date_of_debit),'DD/MM/YYYY) as common_date

          ;

          i hope  u understand .

          Thanx and Regard

          rohit