THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
ts | left | right | outerJoin (current) | outerJoin (suggested) |
1 | null | null - null | ||
2 | null | null - null | ||
3 | A | A - null | A - null | |
4 | a | A - a | A - a | |
5 | B | B - a | B - a | |
6 | b | A - b B - b | A - b B - b | |
7 | null | null - a null - b | ||
8 | null | A - null B - null | ||
9 | C | C - a C - b | C - a C - b | |
10 | c | A - c B - c C - c | A - c B - c C - c | |
11 | null | A - null B - null C - null | ||
12 | null | null - a null - b null - c | ||
13 | null | A - null B - null C - null | ||
14 | d | A - d B - d C - d | A - d B - d C - d | |
15 | D | D - a D - b D - c D - d | D - a D - b D - c D - d |
...