in Firebird 1.0 we use this and it works fine:

Select ZiBelegNr, Min(SplitDate) as "Splitter-Datum" from RsvKat
group by ZiBelegNr
having (SPLITDATE is not null)

I want those ZiBelegNr entries that have for the "ZiBelegNr" only
entries with Splitdate not null.
e.g.
ZiBelegNr Splitdate
1 08/08/2003
1 NULL
2 08/08/2003
3 NULL
ZiBelegNr=2 is what i want to get.

But in fb1.5 it doesnt work (error). I need fb 1.5 for windows 2003.
I tried
Select ZiBelegNr, Min(SplitDate) as "Splitter-Datum" from RsvKat
group by ZiBelegNr, splitdate
having (SPLITDATE is not null)

That SQL works, but i get the wrong result.

Any Idea what to do

Thanks Richard