I do it everyday, they are on the same machine and installation, but most of my queries span 2 to 4 databases. I can't get it it work on ODBC queries though, but PHP does it fine and so does the mysql command line.
But I would be interested to know if there is any problems or reason not to do this. It seems to be the way to bring more organization to the db layout from my perspective. KL Jeff McKeon wrote: > I have an existing database with a lot of information, I need to create > a new database to record inventory information that pertains to records > in the first database. I'd like to keep these two database's separate. > > Is it possible to relate a record in one database to a record in another > and do queries that pull from both databases? > > Thanks, > > Jeff > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
