I need to select data using SQL Passthru ( SQLExec() ) from multiple permanent tables into an intermediate result set, then join the intermediate result set and some of the permanent tables to create a final result set. I cannot seem to be able to get this to work. Can this be done without using a stored prodecure, and if so, how? MS SQL Server 6.5.

Thanks,
Bill