* Roger Baklund
> It is even possible to do this with one select statement and four
> left joins to the same table, but it is a bit complicated:
>
> select table.*,next.id as next,prev.id as prev
> from table
> left join table as prev on
> prev.id < table.id
> left join table as prev2 on
* Mark Lo
> Row 10ID00010need this value
> Row 11ID00025have this value on hand
> Row 12ID00063need this value
>
> The questions is how do I find out the values in Row 10 and Row 12, if and
> only if I only have one data that is "ID00025" (select * from table where
> field=
