Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL to not include certain records
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00809217
Message ID:
00809317
Vues:
33
>>I'm trying to exclude any records with the EMPID = 7260 AND PLANID = 2571. If the EMPID = 7260 and
>>the PLANID = 1234, then I do want the record. The SQL below is removing all records with a PLANID of
>>2571. I'm trying to do this quickly for a production issue. What should the syntax be?

To generalize the answer you got here:

NOT(A AND B) = NOT A OR NOT B
NOT(A OR B) = NOT A AND NOT B
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform