db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Geoff hendrey <geoff_hend...@yahoo.com>
Subject why is column being returned?
Date Thu, 03 Jul 2008 00:39:57 GMT
Hi,

I am doing something like:

SELECT 
    "A"."C1" AS "A.C1", 
    "A"."C2" AS "A.C2"
FROM 
    ATABLE AS "A"
WHERE
    "A"."C1" = "X"
ORDER BY
    PK

Does it make sense that PK should be returned in the result set? I expected ONLY "A.C1" and
"A.C2" to be the column names returned by JDBC...but I see "PK" as well. It may be a bug in
my code somewhere else, or is it possible that the ORDER BY is forcing "PK" to be returned?

-geoff
Mime
View raw message