db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Donald McLean" <dmclea...@gmail.com>
Subject Re: Derby complains on SQL that has ORDER BY that order column is not in query result, but it's there
Date Sun, 20 Jan 2008 15:15:16 GMT
But didn't you select it "as pos18_37_"?

On Jan 20, 2008 9:35 AM, Roman Puchkovskiy
<roman.puchkovskiy@blandware.com> wrote:
> as visibility17_37_, menuitem0_."pos" as pos18_37_, menuitem0_."js_onclick"
> Error is produced: "The ORDER BY clause may not contain column 'pos', since
> the query specifies DISTINCT and that column does not appear in the query
> result."
> But "pos" column is in 'select' clause!

View raw message