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
