Multiple tables in FROM
Inspired by Leetcode "Consecutive numbers" question
Let's take this example table first:
Results in simple 8 lines:
When I use the same table 3 times in the FROM clause:
512 rows..But why? 8*8*8 = 512.
So you need to narrow that combination down with the commented part:
Now we have the same table, 3 times, without the weired combinations.