Re: full join question...

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