Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL syntax for the following
Message
From
31/07/2007 08:43:48
Tamar Granor
Tomorrow's Solutions, Llc
Elkins Park, Pennsylvania, United States
 
 
To
31/07/2007 02:12:51
Doug Johnston
Megamotza P/L
Mornington, Australia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: SQL syntax for the following
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01244721
Message ID:
01244826
Views:
15
>Hi Sergey,
>
>I tried your solution, but get "Queries of this sort are not supported" error.
>
>Regards
>Doug Johnston
>

That's because VFP (including VFP 9) doesn't support TOP n in a correlated subquery.

Tamar
Previous
Reply
Map
View

Click here to load this message in the networking platform