>
> Hello
> I need to make an update for current record and the record immediately
> previous the current one.
>
> is there a way to do it in one sql ?
>
> thanks
>

there's no real sense of "previous" in an SQL database. what do you mean?
Alan