eliminating cross join
I was solving this issue
and found the answer using cross join. However, this query is taking a lot of time as the cross join is resulting in several billions of rows. I want to achieve the same result without cross join.
is there a way to achieve this?