Re: Help with strange join

From: Victor Spång Arthursson <victor(at)tosti(dot)dk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Help with strange join
Date: 2005-02-07 11:34:39
Message-ID: 8a5551705e37216260b6f21194faf215@tosti.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Rylander 2005-02-07 12:30:49 Re: Help with strange join
Previous Message Ben-Nes Yonatan 2005-02-07 11:10:29 Re: mysql load_file() function