Yes, quite possible. Subject to the security on both servers allowing =
such action.

Syntax is somewhat like this:

SELECT
a.Column1
, a.Column2
, b.Column5
, b.Column6
FROM Server1.MyDatabase.dbo.MyTable a
JOIN Server2.OtherDatabase.dbo.OtherTable b
ON a.KeyColumn =3D b.KeyColumn
WHERE ( a.CriteriaColumn =3D CriteriaA
AND b.CriteraColumn =3D CriteriaB
)


--=20
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.=20
Most experience comes from bad judgment.=20
- Anonymous


[quoted text, click to view]