We need to perform a simple activity where I used outer join and merge . The purpose of merge is to actually unite both the tables to proceed further . Since the entries present in the result table are not in source table , there are null entries which are expected . I would like to replace all the null values with the values of the present in the source table . I provide screenshot for better clarity.
Table 1: ( Source table )
Table 2: ( After performing join)
Merged result (Merging Table 1 and Table 2 ):