Some time ago I had the problem, that I have to display two or more rows
of a table in just one row in a Query. Something like that:

ID | VALUE
1 | 25.0
2 | 13.0

And the result of the query looks:

a.ID | a.VALUE | b.ID | b.VALUE
1 25.0 2 13.0

I solved the problem, with the query Helen told me:
select a.ID, a.VALUE, b.ID, b.VALUE from
MYTABLE a, MYTABLE b where
a.ID=1 and b.ID=2

Now I have the problem, that this query should be editable. In the grid,
that displays this query a.VALUE and b.VALUE should be editable. But
when I try to post the query, it doesn't know, which VALUE belongs to
which ID.
Exists there a solution for my problem, for example a UpdateSQL, that I
have to built dynamicly ?


Guido.