I am in need of a way to do an 'insert ... select' statement that spans multiple databases. I would essentially be joining table A from database A to table B from database B where table B lacks table A data.
Any suggestions on how to connect (but moreso) utilize more than one database connection simultaneously?
