I am not sure to be honest, there may be a historial reason.
I do know the AML database is a "LIVE" database where updates can occur at
anytime while the database containing the failing parts only gets updated on
a nightly basis from an AS400 system so it only contains data up to
yesterday. This may be the reason why they exist in different databases.
Willie McSweeney
Memory Component Engineer
EMC,
Ovens,
Co.Cork, Ireland.
Tel +00353-21-4281412
Fax +00353-21-4281898
Email <[EMAIL PROTECTED] >
> -----Original Message-----
> From: Brett W. McCoy [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 01, 2001 4:48 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: sql table joins
>
> On Tue, 1 May 2001 [EMAIL PROTECTED] wrote:
>
> > The databases are both microsoft sql. As you say it looks like DBI does
> not
> > support what I would like to do when the tables are in different
> databases.
> > I will just have to continue what I have right now which is read in from
> > one, store in a hash and the use the hash keys to query the second
> database.
> > the only problem with this is that it ran a little slow and I felt
> getting
> > SQL to do this compare would be faster.Thanks any way
>
> Is there a reason they are in different schemas altogether?
>
> -- Brett
> http://www.chapelperilous.net/btfwk/
> ------------------------------------------------------------------------
> Lizzie Borden took an axe,
> And plunged it deep into the VAX;
> Don't you envy people who
> Do all the things ___YOU want to do?
