replace into replicated table select * from non replicated table

[Kevin Joudrey]

replace into replicated table select * from non replicated table

i need to perform a query that accesses data from one server and puts it into another... possible?

i have one server "master" (the master) that is a work-horse machine that has a work database that is used to create a table of data that then needs to be inserted into slave (the slave) in a master-slave replicated environment.

the optimal situation is this:

replace into master.databaseA.inventory_table
(field list)
select * from master.databaseB.inventory_work_table
(field list)


the problem arises when the statement reaches the slave, the mysql server cannot find databaseB because it only exists on the master.
only the inserts to the master.databaseA.inventory_table want to be replicated, but the literal statement is carried over to the slave and when attempt to run, it cannot see master tables while on slave.