Select z databazi s relaci 1:N

[Zdeněk Böhm]

> > Id     XXX
> > -------------
> > 2       1
> > 2       2
> >
> > Jde to?
>
> Jiste, napriklad
>
> select database1.id, databaze2.xxx
> from database1, databaze2
> where database1.id = databaze2.databaze_id
> and not exists (
> select 1 from databaze2 databaze22
> where database1.id = databaze22.databaze_id
> and databaze22.xxx = 3
> )
>
> Netestovano. Pokud mate server, ktery by neumel not exists, da se
> pouzit i not in, pripadne outer join.

No, konkretne je to pro MySQL, ale kdyz jsem to vcera vecer honil v
dokumentaci, nasel jsem tam vyslovne napsano, ze MySQL neumi select ve
where. Ale berte me s rezervou, jsem bidny zacatecnik. Urcite vas napad
vyzkousim. Diky.

Zdenek Bohm