This content has been marked as final. Show 2 replies
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;