5 Replies Latest reply: Dec 19, 2017 3:10 AM by maayan hadad RSS

    Join 2 tables with a condition

    maayan hadad

      Dear Community,

       

      I have 2 tables and that  I want to connect them with a condition And create a new field

      For example:

      Table A:

      table a.PNG      

      Table B:

      table b.PNG

      When the USERID is the same and ACTIVITYDATE in Table A is between TimeStart And TimeEnd in Table B Create a new field in

      Table A with the matching TimeStart


      Like this:

      table c.PNG
      Is it possible to do this?

      If so then I would be happy to help