9 Replies Latest reply: Sep 16, 2014 4:24 AM by surendra chunduri RSS

    joining three tables with out any common coloumn

    surendra chunduri

      Hi all,

      I been posed by this question by a colleague.

      here is the scenario.

      there three tables

      table1 :

      A,

      B,

      C

      table2:

      E,

      F,

      G,

      Table3:

      H,

      I,

      J

      and the requirement is i need to use these three tables and create a new table where i just need the first coloumns from the three tables.

       

      Please help me with this.

       

      the out put could be like this as per the question

       

      Table 4:

      A,

      E,

      F

       

      i thought of using a link table to connect all three but i am not sure whether i am taking the correct approach or not.

      Please guide me through it