4 Replies Latest reply: Dec 5, 2012 8:26 AM by A. Drieux RSS

    Join on tables

    978112
      We have 3 tables

      T1 T2 T3
      a1 a2 c3
      b1 b2 d3
      c2
      d2

      They are joined on conditions:
      T1-T2:
      a1=a2

      and T2-T3:
      c2=c3

      The requirement is we want to join the tables as:
      T1-T2:
      a1=a2 or b1=b2
      and T2-T3:
      c2=d2 or d2=d3

      Can this be done?
      Then, what will happen to the cases:
      1. When a1, d2 is given
      2. b1, c2 is given