Joachim Breuer wrote:

You might want to ask this in the IB group as this will be 100% a server issue.

One thing you can try though is alias inside the derived table and qualify those
columns. Like

(select kad.kdKundenNr, max(kad.kdBestelldatum) as dBestelldatum from ADS kad
group by kad.kdKundenNr) as KADS2

Derived tables are new in 2017 so there are bound to be some issues in them.
You can also try the with version of it

WITH KADS2 as (select kdKundenNr, max(kdBestelldatum) as dBestelldatum from ADS
group by kdKundenNr)
select KADS1.*
from ADS as KADS1 join KADS2 on
KADS1.kdKundenNr = KADS2.kdKundenNr and
KADS1.kdBestelldatum = KADS2.dBestelldatum

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)

Hello Jeff,
thanks for your response. WITH did not helped.

Here is the table structure:

CREATE TABLE "ADS"
(
"KDKUNDENNR" INTEGER,
"KDBESTELLDATUM" DATE,
"KDVKPREIS" DOUBLE PRECISION,
"KDEKPREIS" DOUBLE PRECISION,
"KDDATUM" DATE,
"KDAP" SMALLINT,
"KDSYSTEM" SMALLINT,
"KDVERSION" SMALLINT,
"KDSERIENNR" VARCHAR(7) COLLATE DE_DE,
"KDVALIDATION" VARCHAR(5) COLLATE DE_DE,
"KDBEMERKUNG" BLOB SUB_TYPE TEXT SEGMENT SIZE 80
);

CREATE UNIQUE INDEX "IDX_KDPRIMARY" ON "ADS"("KDKUNDENNR", "KDBESTELLDATUM");