Re: Help with strange join - Mailing list pgsql-general

From Victor Spång Arthursson
Subject Re: Help with strange join
Date
Msg-id 8a5551705e37216260b6f21194faf215@tosti.dk
Whole thread Raw
In response to Re: Help with strange join  (Mike Rylander <mrylander@gmail.com>)
Responses Re: Help with strange join
List pgsql-general
2005-02-04 kl. 20.36 skrev Mike Rylander:

> How about:
>
> SELECT r.* FROM opskrifter r JOIN opskrifter_content c ON (r.nummer =
> c.opskrift) JOIN opskrifter_ingredienser i ON (c.ingrediens = i.id)
> WHERE EXISTS ( SELECT l.relid FROM languages l WHERE  l.relid =
> i.betegnelse GROUP BY l.relid HAVING COUNT(DIStINCT l.lang) = 1);

Hi and thanks for your answer!

Could you please try to break this SQL down and try to explain what it
does, and also show how to change language…

Sincerely

Victor Spång Arthursson


pgsql-general by date:

Previous
From: "Ben-Nes Yonatan"
Date:
Subject: Re: mysql load_file() function
Next
From: Mike Rylander
Date:
Subject: Re: Help with strange join