Hi Del, the answer is yes, this is perfectly doable, either through
code from Fox, or in the SQL Enterprise Manager environment. InFox code would be something like this:

OPEN DATABASE MyDatabaseName
SET DATABASE TO MyDatabase Name

CREATE SQL VIEW MyViewName REMOTE CONNECTION MyConnectionName AS ;
SELECT a.MyTable1Field1, a.MyTable1Field2, b.MyTable2Field1 ;
FROM MyLinkedServerName.MyDatabaseName.dbo.MyTable1Name a INNER JOIN ;
dbo.MyTable2Name b ON a.MyTable1Field1 = b.MyTable2Field1



Good luck!

>Is it possible to create a remote view which JOINs a SQL2005 table with a table within a linked server? Can this be done within the context of a single connection?