My God, that was quick!
Hang on Cetin and I'll give that a try then get back to you.
Thanks
Terry
>
>select * from RZStop r1 ;
> where r1.Gen = (select max(Gen) from RZStop r2 where r1.zone = r2.zone)
>
>select * from RZStop r1 ;
> where r1.zone = 20 and ;
> r1.Gen = (select max(Gen) from RZStop r2 where r1.zone = r2.zone)
>
Cetin
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.