On 5 apr 2006, at 18.37, Jonas F. Henriksen wrote:
ehh, sorry, yes, I also want to retrieve other values from the table,
but I left them out for clarity (which made it maby less clear...).
Maybe it makes more sense if you define the table as
CREATE TABLE testtable (
depth integer,
measuretype integer,
operation integer,
value float
);
...where I'm actually interested in the value...
Well, is there something else I don't get or couldn't you just select
that as well (perhaps without the DISTINCT then)?
SELECT depth, value FROM testtable WHERE measuretype IN (1040, 4001);
Mvh,
Niklas Johansson
Tel: 0322-108 18
Mobil: 0708-55 86 90
