Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Thanks Sergey
>>This is really helpful. Now I realize that my statement in the post where I said that I thought not in and not exists were functionally equivalent, is wrong. This is a much better explanation of why not to use "IN" than the post that Nadia referenced. (Thanks anyway though Nadia)
>>
>>I still don't understand though why exists works. What is it functionally equivalent to? Why doesn't it care about nulls?
>>
>
>The EXISTS only checks if a record exists thet satisfies the conditions. It does not return any data.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement