Re: full join question...

[Niklas Johansson <spot(at)tele2(dot)se>]

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



Sincerely,

Niklas Johansson