12 Replies Latest reply: Aug 13, 2013 11:27 AM by Piet Hein van der Stigchel RSS

    To link 2 tables in a graph, when there is no link in the loader

    Ankri Laurent

      Hi

       

      I have 2 tables that are no linked

       

      QV_TOU_CONTACT

      CONTACT_NUM

      TEL_1 (format exemple 06020202)

      TEL_2

       

      QV_TIKAL

      DATE

      TEL_TIKAL_1 (format exemple 3306020202)

      TEL_TIKAL_2

      USER

       

      I have done the graphic bellow, from the table QV_TIKAl :

       

      DATE     USER     TEL_TIKAL_1     TEL_TIKAL_2

       

      I want to add the column CONTACT_NUM from CONTACT_NUM when

      TEL_TIKAL_1=TEL_1 or =TEL_2

      or

      TEL_TIKAL_2=TEL_1 or =TEL_2

       

      How can I do this ?

       

      Thanks