Joining Across Different Machines

[Mark Burdis]

I have a simple system where I have a master instance being replicated to around 20 slaves running a factory management/datalogging system. I anticipate installing a completely new system in the next year or so for a new factory we are currently building. This system will probably use similar (but different) applications and so I think I will set-up another server-replicate system there. My question is:

How can I join tables across different machines? For example, I know I have some inconsistencies in one of my tables from master to replicates, and would like to track down how many records are affected. I tried the following:

SELECT a.idtbl from srvr1.db1.tbl a, slv1.db1.tbl b
WHERE a.idtbl=b.idtbl AND a.rec1<>b.rec1;

I get a syntax error in my SQL. I found that the following also did not work:

SELECT * from localhost.db1.tbl1;

Any help would be gratefully received. Thanks in advance.