By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
✓
✓
| next2 | next_stream | factor | stream |
|---|---|---|---|
| next1 | next_stream1 | 1 | 1 |
| next3 | next_stream3 | 3 | 3 |
| next4 | next_stream4 | 4 | 4 |
| next7 | next_stream7 | 7 | 7 |
| next9 | next_stream9 | 9 | 9 |
| next2 | (SELECT next_stream FROM stream_order2 B WHERE A.factor = B.stream ) |
|---|---|
| next1 | next_stream1 |
| next2 | null |
| next3 | next_stream3 |
| next4 | next_stream4 |
| next5 | null |
| next6 | null |
| next7 | next_stream7 |
| next8 | null |
| next9 | next_stream9 |
| next9 | null |
| next9 | null |
✓
| next2 | next_stream | factor | stream |
|---|---|---|---|
| next_stream1 | next_stream1 | 1 | 1 |
| next2 | next_stream2 | 2 | 12 |
| next_stream3 | next_stream3 | 3 | 3 |
| next_stream4 | next_stream4 | 4 | 4 |
| next5 | next_stream5 | 5 | 31 |
| next6 | next_stream6 | 6 | 33 |
| next_stream7 | next_stream7 | 7 | 7 |
| next8 | next_stream8 | 8 | 36 |
| next_stream9 | next_stream9 | 9 | 9 |
| next9 | next_stream9 | null | 10 |
| next9 | next_stream9 | 19 | null |