Help with strange join

From: Victor Spång Arthursson <victor(at)tosti(dot)dk>
To: pgsql-general(at)postgresql(dot)org
Subject: Help with strange join
Date: 2005-02-04 08:44:15
Message-ID: d34f8ec91e8a318f32afb2529016660f@tosti.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

God morning, everybody!

I have a problem that I don't seem to be able to solve by my self,
thats why I kindly ask the list now…

I have a database containing some tables, containing different receipts.

Every receipt have an unknown number of ingredients linked to it, and
every ingredients name is in a separate table sincce it needs to be
translated to different languages.

The tables are link according to the following:

receipts <- related_ingredients <- ingredients <- languages

On a listpage I want to list (ten and ten) all receipts that has _all
the ingredients translated_.

My problem is how to find out that every ingredient is translated.

If I just do JOINs, I will not be able to find out if only one or all
of the ingredients are translated. What I need is something that, for
example, returns the receiptnumber if, and only if, the number of
translated ingredients that is returned (after joining ingredients with
languages) is the same as the number of entrys in the table
"related_ingredients".

Since I'm really close to deadline on this project and standing still
for the moment, I really would appreciate some help right now...

Best regards,

Victor Spång Arthursson

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Julian Scarfe 2005-02-04 09:03:40 Re: pgpool 2.5b2 released
Previous Message David Fetter 2005-02-04 07:58:23 Re: mysql load_file() function