Randy,

There are a couple of ways to do this, but since you asked about temp tables...

You can create temp tables by doing the following;

SELECT <columns> INTO #TempTableA FROM <files and joins>
SELECT <columns> INTO #TempTableB FROM <files and joins>
SELECT <columns> FROM #TempTableA, #TempTableB <where whatever>
DROP TABLE #TemptableA
DROP TABLE #TempTableB

The #TemptableA will create a temp table that's unique to the connection. And then you drop them at the end.

Hope that helps...
Kevin