Join two identically structured views

[mah01]

Hi

I have two views that contain the same columns of the same types. They also have the same amount of rows with the same primary keys.

E.g.

VIEW_A
ID    VALUE
1    (null)
2    1001
3    (null)
 
VIEW_B
ID    VALUE
1    81007941
2    (null)
3    (null)
 

I would like to create a third view VIEW_COMBO that combines the two views, getting as many values as possible. I.e. getting the value 81007941 from VIEW_B and the value 1001 from VIEW_A and (null) for the third row where no value exists.

E.g.

VIEW_COMBO
ID    VALUE
1    81007941
2    1001
3    (null)
 

Is this possible somehow to write a sql query that does that?

Best regards,
Mattias

[docdiesel]

Hi,

if the destination would be a table, then it could be realised with a MERGE statement. But by the way - what about a PK=4 with VALUE=123 in View_A and VALUE=456 in View_B? Which value should show up in the target table/view ?

Regards,

Bernd