By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
24 rows affected
WO |
---|
1 |
2 |
3 |
Nr | WO | COSTL |
---|---|---|
11 | 1 | 1 |
12 | 1 | 2 |
13 | 1 | 3 |
11 | 2 | 4 |
12 | 2 | 5 |
14 | 3 | 6 |
15 | 1 | 10 |
16 | 1 | 2 |
17 | 1 | 1 |
Item | Split | WO | VK | Anzahl |
---|---|---|---|---|
0 | 1 | 1 | 1 | 1 |
11 | 2 | 1 | 2 | 2 |
11 | 3 | 1 | 3 | 1 |
11 | 4 | 1 | 4 | 1 |
12 | 5 | 1 | 5 | 1 |
13 | 6 | 1 | 6 | 1 |
0 | 1 | 2 | 7 | 1 |
11 | 2 | 2 | 1 | 1 |
11 | 3 | 2 | 1 | 1 |
11 | 4 | 3 | 1 | 1 |
12 | 5 | 3 | 1 | 1 |
12 | 6 | 3 | 1 | 1 |
WO | Nr | costl | GesamtMAT |
---|---|---|---|
1 | null | null | 1 |
1 | 11 | 1 | 11 |
1 | 12 | 2 | 5 |
1 | 13 | 3 | 6 |
WO | Nr | Costl | GesamtMAT |
---|---|---|---|
1 | 11 | 1 | 23 |
1 | 12 | 2 | 23 |
1 | 13 | 3 | 23 |
1 | 15 | 10 | 23 |
1 | 16 | 2 | 23 |
1 | 17 | 1 | 23 |
6 rows affected
WO | Nr | GesamtMAT | COSTL |
---|---|---|---|
1 | 11 | 11 | 1 |
1 | 12 | 5 | 2 |
1 | 13 | 6 | 3 |
1 | 15 | null | 10 |
1 | 16 | null | 2 |
1 | 17 | null | 1 |