[snip] Can I select from one db and insert into another? also...Can I join to a remote db? [/snip]
Yes, if you can share the connection. Consider... INSERT INTO db1.tableI (`stuff`) SELECT `stuff` FROM db2.tableII Doing a join to a remote database is not possible as you would have to have two connections that are aware of each other, so that... INSERT INTO serverA.db1.tableI (`stuff`) SELECT `stuff` FROM serverB.db2.tableII would work. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]