MySQL a... Zavody prasatek :-))

[Jakub Holcman]

Ahojky,
  nevim jak v MySQL, ale obecne (dle standardu) by se snad
  dal pouzit vnoreny select. Tedy neco jako:

> 2) Vsechna prasatka ktere se ucastni zaroven zavodu na 300m a 500m

  SELECT DISTINCT  Jmeno FROM Prasatka, PrasatkaVZavodech, Zavody WHERE
   Prasadka.IDprasatka=PrasatkaVZavodech.IDprasatka AND
   PrasatkaVZavodech.IDzavodu=Zavody.IDzavodu AND delkazavodu='300' AND
   Prasatka.IDprasatka IN (
     SELECT IDPrasatka FROM PrasatkaVZavodech, Zavody WHERE
     PrasatkaVZavodech.IDzavodu=Zavody.IDzavodu AND delkazavodu='500'
   )


> 3) Vsechna prasatka ktera se ucastni behu na 300 metru a zaroven se
> neucastni behu na 500m

  SELECT DISTINCT  Jmeno FROM Prasatka, PrasatkaVZavodech, Zavody WHERE
   Prasadka.IDprasatka=PrasatkaVZavodech.IDprasatka AND
   PrasatkaVZavodech.IDzavodu=Zavody.IDzavodu AND delkazavodu='300' AND
   Prasatka.IDprasatka NOT IN (
     SELECT IDPrasatka FROM PrasatkaVZavodech, Zavody WHERE
     PrasatkaVZavodech.IDzavodu=Zavody.IDzavodu AND delkazavodu='500'
   )


Snad to pomuze.
Jakub.