select * from localdb.dbo.localtable as t1full outer join linkedserver.remotedb.dbo.remotetable as t2on t1.col1 = t2.col1