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
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 (for
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 thi
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
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 qu