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
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
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
In a message dated 9/15/03 9:50:22 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
Jeff McKeon wrote:
Is it possible to relate a record in one database to a record in another
and do queries that pull from both databases?
Programmatically yes. Using referential integrity (foreign
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