Re: full join question...

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
>
>
>