2 Replies Latest reply: Aug 5, 2016 2:04 AM by sandesh ag RSS

    How to Concatenate when we have more than two tables to join

    sandesh ag

      Hi

       

      I have a requirement where more than two tables are involved in joining.

       

      For ex. Consider 6 tables like Table 1,2,..6

       

      I have to left join between Table 1,Table 2,Table 3

       

      I.e.,

       

      Table 1

      Join (Table 1)

      Table 2

      Join (Table 1)

      Table 3

       

      Similarly I joined remaining

       

      Table 4

      Join(Table 4)

      Table 5

      Join(Table 4)

      Table 6

       

       

      Now I have to consider union between Table 1, Table 2, Table 3 (Union) Table 4,Table 5, Table 6.

       

      So I Considered like

       

      Table 1

      Left Join (Table 1)

      Table 2

      Left Join (Table 1)

      Table 3

       

      Concatinaton(Table1)

       

      Table 4

      Left Join(Table 4)

      Table 5

      Left Join(Table 4)

      Table 6

       

      But while Loading it is throwing error and not able to perform Concatination operation between those two group of tables (Table 1,2,3 with Table 4,5,6)

       

      Please help me in this scenario.