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
Hi,
Yes you can do that. Just prefix table name with database name in your query:
select * from table1,database2.table2 where table1.field1=database2.table2.field2
Hope this helps, Joseph Bueno
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
