The only idea that came to my mind for doing that in SQL is
- first, for every BY group in the two tables, create a counter variable, starting with 1 in every group
- then, do an outer join on the original BY variable and the counter variable.
... View more