when I try to join across two servers, where one is mssql, I have to lodge myself into the mssql side with uses:
use dbserver.dbname; use dbserver.schemaname; select blah from mysqlserver.dbname.table a1 inner join tablename a2 on a1.field = a2.field where... Any time I try to reference the table name with context on the mssql server the query blows up because of the schema name and no permutation seems to work. Why is this happening and what can I do about it? -- Jonathan Bayles
