ZZartin (3/5/2015)
Why do you think the process of create and populating temp tables will be less confusing?
Because you would be breaking the problem into pieces which inherently simplifies the problem. Instead of trying to conceptualize the interrelattionships of Table1, Table2, Table3 and Table4 as a single complex problem.