8 Replies Latest reply: Jun 16, 2016 11:35 AM by Stefan Wühl RSS

    Joining tables

    akshata tare

      I have three tables t1, t2 and t3 with keys k1, k1+k2 and k2 respectively. (Essentially, t2 connects t1 and t3) I need to filter the records from t2 which match the key values in t1 and then join the resultant to t3. Can any one suggest the proper join conditions?

      If I use left join with t2 as the main table, I end up picking extra values from t1 and if I use t1 as the main table then there is no way for me to get data from t3.