Hi

I have a table.
It contains data like:

Y_AKSE X_AKSE FIELDVALUE
-------------------------
46 BLACK 1
48 BLACK 2
50 BLACK 3
46 WHITE 4
48 WHITE 5
50 WHITE 6


I would like to do a SELECT statement, that returns something like:

46 1 4
48 2 5
50 3 6

Which is the numbers represented by BLACK and WHITE.
Im not sure it can be done, but if it can it will help a lot.

The problem is, that Y_AKSE can have a lot of distinct values as can
X_AKSE.
This example is just a short simple on.

Regards
Michael