Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query using not in clause
Message
From
25/02/2004 12:07:53
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brazil
 
 
To
25/02/2004 12:02:39
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brazil
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Query using not in clause
Miscellaneous
Thread ID:
00880737
Message ID:
00880756
Views:
10
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!
Previous
Reply
Map
View

Click here to load this message in the networking platform