Select ,,, into #temp1 from ... Union select ,,, ... select , , , into #temp2 from ... inner join #temp1 on ... select , , , into #temp3 from ... union select , , , from... union select , , ,... select , , , from #temp2 full join #temp3 on ... -- I usually do this because they seem to vanish only when you disconnect drop table #temp1 drop table #temp2 drop table #temp3And that's it. I'm doing this quite often, when speed requires and when all I need is on the server. Sometimes there's still some more to do in VFP later, depending on where the rest of the data are (i.e. I may have pulled some other recordset already, and it's simpler to reuse it in Fox than to pull the same set again for purity's sake).