Subject [firebird-support] Re: fb 1.0 => 1.5 having doesnt work any more
Author Svein Erling Tysvaer
At 07:27 09.07.2003 +0000, you wrote:
>Or is there another wya to get the result i want to have?

Yes, as I suggested yesterday

Select distinct ZiBelegNr, SplitDate as "Splitter-Datum"
from RsvKat k1
where not exists(
Select * from RsvKat k2
where k1.ziBelegNr = k2.ziBelegNr and
(k2.splitdate < k1.splitdate or k2.splitdate is null)

should return what you want.