2 Replies Latest reply: Apr 25, 2018 5:19 PM by Yücel Özer RSS

    Joining Tables

    Yücel Özer

      Dear Friends,

       

      I have two tables.

       

      When I select 'class1' field from Table1, the duration values of a, d  and x should be selected  via 'comp' field from Table2.

       

      When I select 'class2' field from Table1, the duration values of b, e  and y should be selected  via 'comp' field from Table2.


      The same things for other fields...

       

      How can I join these tables ?

       

      Thanks for kind reply in advance.

       

      Regards.

       

       

      Table1Table2
      classcomp1comp2comp3studentcompduration
      class1adxstudent1a40
      class2beystudent2b50
      class3cf student3c30
      class4 g student4d60
      e56
      f55
      g59
      x63
      y67
      z35
      s71
      m75
      n79
      v83
      t49