Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Query using not in clause
Message
De
25/02/2004 12:07:53
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brésil
 
 
À
25/02/2004 12:02:39
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brésil
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Re: Query using not in clause
Divers
Thread ID:
00880737
Message ID:
00880756
Vues:
12
Hi Gaylen!

If all policy have the year 2003, you can try this:
Select myCod from myTable group by myCod having count(myCod) < 2


Complete:
Else, try this:
Select myCod from myTable where myCod not in (Select myCod from myTable where myYear = '2004')
I hope this help you!
Erick
Força Sempre!
Strength Always!
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform