Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Max date
Message
 
 
To
11/01/2006 21:27:00
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01085916
Message ID:
01085934
Views:
13
You're welcome.

>It works my friend. Thanks so much.
>Gaylen
>
>
>
>>Try
>>Select policy, exp_mod, eff_date ;
>>	from mytable mt1 ;
>>	WHERE NOT EXISTS ( ;
>>		SELECT * FROM mytable mt2 ;
>>			WHERE mt2.policy = mt1.policy AND mt2.eff_date > mt1.eff_date) ;
>>	into cursor xxx
>>
>>* or
>>
>>Select policy, exp_mod, eff_date ;
>>	from mytable mt1 ;
>>	WHERE eff_date = ( SELECT MAX(eff_date) FROM mytable mt2 ;
>>			WHERE mt2.policy = mt1.policy) ;
>>	into cursor xxx
>>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform