[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