1. I need to run several queries having different fields and conditions on exactly same join of tables.

2. How can i first create such a join of tables in memory and run the queries without re-creating the join of tables again and again for each query.