Is it possible to do a join on the results from a stored procedure to the 
results from a select statement?  In my ASP page I am connecting to a 
stored procedure via a linked server and then trying to join it backup to 
a select statement from a table on the local server.  Any help would be 
appreciated.  Thank you.  Here is a try at the code in my ASP page that I 
am using:

strSQLSpeclty =	"exec lookuptables...getlookuptablevalues 
@tablename=physnprofilespeclty; " & _
"SELECT clinicprogname, practcspecltycode, practcspecltyboardstatus, " & _
"practcsubspecltycode, practcsubspecltyboardstatus " & _
"FROM thrphysnprofile_view " & _
"WHERE enterprsphysnid = '" & strenterprsphysnid & "' " & _
"AND tableargmnt = practcspecltycode "
					 			
Set physnspeclty_rs = ODSDev_CGuser.Execute(strSQLSpeclty)