Apparently you can not reference two temporary tables in 5.1 using a simple join.
I was trying to create test environment based on my tables so that I could have a place to advance on this stored routine. The MEMORY storage engine provided me the comfort of performance and the fact that
