Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL command: syntax needed
Message
From
22/03/2004 19:34:33
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00888526
Message ID:
00888711
Views:
17
Sergey,

>Try
SELECT id_product, year, price ;
>	FROM mytable mt1 ;
>	WHERE year IN ( SELECT MAX(year) FROM mytable mt2
>			 WHERE mt2.id_product = mt1.id_product )
>
Bingo! That's the correlated subquery I was trying to remember.
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform