Well, the problem is I want the result on one row for each depth, so it will fit nicely into a table, like this:
depth measuretype1_value measuretype2_value 10 1.78 2.55 20 2.12 30 3.12 40 1.3 1.4 ...with missing rows for a depth appearing as missing values... Jonas:)) On Wed, 2006-04-05 at 20:06 +0200, Niklas Johansson wrote: > 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 > > > ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
