Table 1: FIELD1 FIELD2 FIELD3 FIELD4 FIELD5 FIELD6(UNIQUE, PK) ------------------------------------------ null 1 2 3 4 8 null 1 1 1 1 9 Table 2: FIELD1 FIELD2 FIELD3 FIELD4 FIELD5 ---------------------------------- 3 1 2 3 4 9 1 1 1 1 4 1 1 1 1 5 1 2 3 4 From this, I would like to obtain Table 1: FIELD1 FIELD2 FIELD3 FIELD4 FIELD5 FIELD6 ------------------------------------------- 3 1 2 3 4 8 5 1 2 3 4 8 9 1 1 1 1 9 4 1 1 1 1 9