Re: AW: replication on single server

2003-03-24 Thread Joseph Bueno
Hi, With MySQL, you can join tables that are in different databases as long as they are on the same server. In your case, you could run: SELECT s.name FROM A.bouncebacks b, subcriber s where s.email = b.email Regards, Joseph Bueno Brandl, Thomas wrote: The thing is that this particular table in da

AW: replication on single server

2003-03-24 Thread Brandl, Thomas
The thing is that this particular table in database 'A' contains bounceback email addresses, all other databases are customer databases containing pretty large subscriber tables. Now I need to find matches between this bounceback table and all other customer subscriber tables. So I'd like to do a j