Hi,

we would need the below shown result-dataset from data shown in Tab1 and Tab2.

Can this be expressed with a select-statement?

Thank you for your help,

Josef Gschwendtner

Tab1

Key1   Value1

1          1000

2          2000

3          3000

4          4000

 

Tab2

Key2       Key1       Value2

1             1               400

2             1               400

3             2             2000

4             3             1000

5             3             1000

6             3               500

 

Result

Key1       Key2       Value

1             1               400

1             2               400

1             null            200

2             3             2000

3             4             1000

3             5             1000

3             6               500

3             null            500

4             null          4000

Note:

In Tab2 are 0 to n related records for each record in Tab1.

In return dataset should be one record with key2 is null if value1 <> sum(value2) for one relation.