I'm trying to cross join a query and it doesn't appear to by working:
SELECT Server1.DatabaseX.dbo.Table1.Field1, Server1.DatabaseX.dbo.Table1.Field2
INNER JOIN Server1.DatabaseX.dbo.Table1 ON
Server2.DatabaseY.dbo.Table1.Field1 = Server1.DatabaseX.dbo.Table1.Field1
WHERE (Server2.DatabaseY.dbo.Table1.Field1 = 1)
I keep getting an error telling me table "Server2.DatabaseY.dbo.Table1" does not exist -- but I can't see anything wrong in my SQL statement?