This content has been marked as final. Show 6 replies
I have Two Load Statements as below
Load a,b,c,d from ...;
Load a,b,d,e,f from ....;
Can we write a statement where table3 which holds a,b,c,d,e,f [ I tried to create a new table3 using JOIN between table1 and table2 what i have found the issue was im able to see the null values for c,d / e,f . My Intention is i don't want to have nulls i want full data for a,b,c,d,e,f columns.
i want to merge vertically of Two tables like from table1 (a,b,c,d) columns with table2 ( e,f) columns.