2 Replies Latest reply: Mar 19, 2012 3:28 PM by Przemysław Wojda RSS

    Concatenate joined tables

    Przemysław Wojda

      Hi All,

       

      in the below code how can I concatenate joined Residents of Table_2 and Table_3 with Table_1? When I leave it as it is now values from Resident Table_3 won't joined.

       

      Table_1:
      SELECT Dim_1, Dim_2, Dim_3 FROM Table_1
      
      Table_2:
      SELECT Dim_1. Dim_2 FROM Table_2
      
      Table_3:
      SELECT Dim_1, Dim_3 FROM Table_3
      
      Conctenate(Table_1)
      LOAD Dim_1, Dim_2 FROM Resident Table_2 Left Join (Table_2) LOAD Dim_1, Dim_3 FROM Resident Table_3
      
      DROP TABLES Table_2, Table_3;
      

       

       

      Regards,

      Przemek