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
