Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to add the two columns(say A & B) from Table 1 to Table 2. Both the tables have one same named column(KEY).Some values in KEY column are different .
Load * From Table2;
Concatenate
Load * From Table1;
This will create one table containing all of the values from both tables (values will not be joined, if identical keys existing they will remain as two separate rows).
If you're looking to join the values based on identical keys, you need to use Join instead of concatenate. As appropriate, you can use Left Join, Right Join, or Outer Join.