1 Reply Latest reply: Oct 24, 2018 3:26 AM by Mark Little RSS

    problem with join

    daisy ch

      Hi

      I have tow tales T1 and T2.

      fields Risk_ID      L1_ID     date    Satus

       

      script

       

      T1:

      Risk_ID & L1_ID& date   as key,

      Risk_ID ,

      L1_ID,

      Date,

        Satus;

       

      outer join(T1)

      T2:

      Risk_ID & L1_ID& date   as key,

      //Risk_ID ,

      // L1_ID,

      //Date,

        Satus;

       

      The above table I am not comment the Status field because in first table status is open and t2 table status is closed.

       

      problem is using  key between two tables L1_ID and Date data not merge.if un comment the L1_ID and Date in table t2 the values come up.but it showing more values. How to resolve this.

        • Re: problem with join
          Mark Little

          HI,

           

          Probably going to need some more information to help on this one, some example data would be helpful.

          What happens when trying to join them i.e. the resulting table?

           

          From the information i would guess that the Data in the Key in in table 1 and 2 is different so they are not joining. The must match exactly, case as well.

           

          Also notice in you script you use date in the key and the field below is Date, the must both be Date as it is case sensitive.

           

          Mark