That's what I thought. Thanks for the advise!! :o) Jeff
> -----Original Message----- > From: Joseph Bueno [mailto:[EMAIL PROTECTED] > Sent: Monday, September 15, 2003 9:26 AM > To: Jeff McKeon > Cc: [EMAIL PROTECTED] > Subject: Re: Joining tables from two different databases > > > 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 > > > > 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]
