Otazka na SQL - NOT IN

[Milan Sorm]

Wed, Feb 07, 2001 ve 11:20:54AM +0000 Roman Starek napsal:
# 
# 	Ja bych videl problem v tomto
# 
# SELECT id FROM k_uzivatele WHERE ___id___ NOT IN (
#         SELECT ___uzivatel___ FROM s_studium_obecne WHERE datum_vyrazeni IS NULL

s_studium_obecne.uzivatel je FK do k_uzivatele(id)

# Tohle by fungovalo jenom v pripade ze sloupce id a uzivatel obsahuji totozna data.
# 
# Byva lepsi pouzivat not exists misto not in. Teda pokud to jde.

cim se ty dva lisi ?

--milan