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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
