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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly