RE: Nexted Selects in DBI for Oracle

[Jones Robert Contr TTMS Keesler]

Grrr, small correction ... 

-----Original Message-----
From: Jones Robert Contr TTMS Keesler
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 3:31 PM
To: [EMAIL PROTECTED]
Subject: Nexted Selects in DBI for Oracle




When I do the following in SQL+ I get the correct elements from PA_Table.
But, when I send this through the DBI in Perl I get records that are also in
both tables, which shouldn't be happening.

$sth=$dbh->prepare("SELECT pas.f1, pas.f2, pas.f3, pas.f4, pas.f5
                    FROM pa_table pas
                     (
                       SELECT f1 from pa_table minus
                       SELECT f1 from st_table
                     ) st
                    WHERE
                     pas.f1 = st.f1
                   ORDER BY f1") || die $dbh->errstr;

Does the DBI has trouble with nested select statements?  

note: The above statement takes records from PA_Table that are not in
ST_Table and displays the first 5 fields.  In both tables the field F1 is
the primary key.  There are no duplicate values in F1 in either table.  


Robert E. Jones, BSCS, BSP
81 CS/SCK, Keesler AFB