I often use temporary tables to hold intermediate results. Does that not work for you?