Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
EXISTS
Message
De
08/02/2001 14:54:43
 
 
À
08/02/2001 10:39:00
Greg Coopman
Gc Systems Corporation
Hollywood, Floride, États-Unis
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Re: EXISTS
Divers
Thread ID:
00473986
Message ID:
00474141
Vues:
19
You can use both NOT IN and NOT EXIST to generate the same results. The following examples show this. You can run them in the Pubs sample database.
SELECT * 
FROM titles
WHERE title_id NOT IN (
	SELECT title_id
	FROM sales )

SELECT *
FROM titles
WHERE NOT EXISTS (
	SELECT *
	FROM sales
	WHERE sales.title_id = titles.title_id)
I'm not sure why you're having problems. Are there NULLs in the vcRequestor or TolasKey columns maybe?

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform