The DBI and DBD::Oracle have no knowledge about what's in the statement.
It's just a string that's sent to the server and the server returns
a bunch of rows.
Tim.
On Thu, Dec 06, 2001 at 03:30:46PM -0600, Jones Robert Contr TTMS Keesler wrote:
>
>
> 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
> WHERE
> (
> SELECT f1 from pa_table minus
> SELECT f1 from st_table
> ) st
> 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
