protoze LEFT JOIN pavel
On 15/03/06, Jan Medek <[EMAIL PROTECTED]> wrote: > Nejak se mi to nezda cele. Kdyz zam IS NULL, jak se muze zam.id rovnat > res.id? > > Pavel Kolesnikov napsal(a): > > 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 >
