I have created a query in an adapter. It generates a Sql Connectivity error: "Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]The multi-part identifier "skip.sysid" could not be bound."

Here is my query:

SELECT ;
		sys.syscode, ;
		com.compipe, ;
		fac.facpoint, ;
		fin.finispdate, ;
		tpn.tpnps, ;
		tpn.tpncaseps, ;
		fin.finremarks, ;
		sys.sysid, ;
		com.comid, ;
		fac.facid, ;
		fin.finid, ;
		tpn.tpnid, ;
		fif.fifid, ;
		tpf.tpfid ;
	FROM ##skiptable AS skip ;
	INNER JOIN systems sys ON ;
		sys.sysid = skip.sysid ;
	INNER JOIN component com ON ;
		com.comid = skip.comid ;
	INNER JOIN facility fac ON ;
		fac.facid = skip.facid ;
	INNER JOIN facinsp fin ON ;
		fin.finid = skip.finid ;
	INNER JOIN tpinsp tpn ON ;
		tpn.tpnid = skip.tpnid ;
	LEFT JOIN facinfo fif ON ;
		fif.fifid = skip.fifid ;
	LEFT JOIN tpinfo tpf ON ;
		tpf.tpfid = skip.tpfid ;

I have verified the temp table ##skiptable is on the server and has the named columns. I have tried "tempdb.dbo.skiptable". I have tried not aliasing it and using its name in the joins, but I get an error. Any ideas?

Thanks.