The simplified version of my question is:
Say I have two tables. T1 contains the columns ID, C1, C2 and C3. Rows in this table represent complete records.
T2 contains the columns ID, C2 and C3. Rows in this table represent incomplete records.
Now, I want to create a view (V1) in which T1's data is replaced with data from T2 based on matching IDs.