again,
> Tino
>
> -Ursprüngliche Nachricht-
> Von: Richard Bayet [mailto:[EMAIL PROTECTED]
> Gesendet: Montag, 22. November 2004 12:30
> An: Apache Torque Users List
> Betreff: Re: Antwort: SQL->Criteria howto
>
>
> Hi all,
>
> Thomas' answer may not be ver
Hi all,
Thomas' answer may not be very accurate (it's simpler than Tino what
Tino's need), but "select vavi_id, max(sequenz) from voravis
where vavi_id = 67537" should be fine.
Of course, if you (Tino) want the max(sequenz) for every distinct
vavi_id, you'll need the IN clause.
Thomas Fischer a