Hi IIya,
Thanks for the reply. I know that your suggestion will work but how do I
construct the prepare statement in DBI
If I do something like
$dbh = DBI->connect ('dbi:ODBC:TotalBoards', 'user', 'password') or die
"could not CONNECT $!";
$dbh_aml = DBI->connect ('dbi:ODBC:AML', 'user', 'password') or die "could
not CONNECT $!";
$sth = $dbh->prepare(qq{SELECT TotalBoards.EMC_PN FROM TotalBoards,
AMLMaster WHERE TotalBoards.SYMPTOM_CODE LIKE ? AND TotalBoards.EMC_PN =
AMLMaster.AMLPN AND TotalBoards.REC_DATE BETWEEN ? AND ?}) or die "Couldn't
prepare statement: " . $dbh->errstr;
I get an error "invalid object name AMLMaster". This is I guess because $dbh
is the connection to TotalBoards and knows nothing about the AMLMaster
table. I have another $dhh_aml connecting to AMLMaster. My question is how
do you write a prepare statement as above that works. Can you get $dbh to
connect to both tables at the same time???
Willie
Willie McSweeney
Memory Component Engineer
EMC,
Ovens,
Co.Cork, Ireland.
Tel +00353-21-4281412
Fax +00353-21-4281898
Email <[EMAIL PROTECTED] >
> -----Original Message-----
> From: Sterin, Ilya [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 01, 2001 3:19 PM
> To: '[EMAIL PROTECTED] '; '[EMAIL PROTECTED] '
> Subject: RE: sql table joins
>
> You sure can, that's just a simple join, but you have to also use the
> table2
> in the from clause. Like this...
>
> SELECT table1.failed_parts FROM table1, table2 WHERE table1.failed_parts =
> table2.valid_parts;
>
> Ilya Sterin
>
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Sent: 05/01/2001 8:04 AM
> Subject: sql table joins
>
> Hi,
> I am using perl DBI to access an sql server database.
> One table has component part numbers that have failed, keyed in by
> operators. I need to read in and count these which is no problem but I
> also
> need to compare them with an approved parts table to make sure that they
> are
> valid part numbers. Currently I am doing this by reading the failed
> parts
> into a hash and then using the hash keys as placeholders to query the
> parts
> valid table.
> Is it possible with DBI to do something like
> SELECT table1.failed_parts FROM table1 WHERE table1.failed_parts =
> table2.valid_parts
>
> thanks Willie
>
>
> Willie McSweeney
> Memory Component Engineer
> EMC,
> Ovens,
> Co.Cork, Ireland.
> Tel +00353-21-4281412
> Fax +00353-21-4281898
> Email <[EMAIL PROTECTED] >
