« Return to Thread: why is column being returned?
why is column being returned?
by Geoff hendrey
::
Rate this Message:
Some parts of this message have been removed.
Learn more about Nabble's security policy.
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
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
« Return to Thread: why is column being returned?
| Free Forum Powered by Nabble | Forum Help |
