| Subject | [firebird-support] Re: fb 1.0 => 1.5 having doesnt work any more |
|---|---|
| Author | Svein Erling Tysvaer |
| Post date | 2003-07-09T08:09:12Z |
At 07:27 09.07.2003 +0000, you wrote:
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.
Set
>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.
Set