On 15/03/06, Ondřej Fafejta KYBERIE <[EMAIL PROTECTED]> wrote: > 2. EQL dotaz typu: > SELECT res FROM Osoba res LEFT JOIN Zamestnanec zam WHERE res.id=zam.id > AND zam IS NULL > To ovšem nefunguje.
Mozna Vam uplne neporadim, ponevadz nevim presne jak funguje EQL, ale v SQL byste spravne mel JOIN-ovaci podminku hodit do LEFT JOIN ON namisto WHERE, pak by to melo fungovat. Tedy spis: SELECT res FROM Osoba res LEFT JOIN Zamestnanec zam ON res.id=zam.id WHERE zam IS NULL Pavel
