SQL syntax for the following

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

SQL syntax for the following

Message

31/07/2007 08:43:48

Tamar Granor
Tomorrow's Solutions, Llc
Elkins Park, Pennsylvanie, États-Unis

31/07/2007 02:12:51

Doug Johnston
Megamotza P/L
Mornington, Australie

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: SQL syntax for the following

Versions des environnements

Visual FoxPro:

VFP 9

OS:

Windows XP SP2

Database:

Visual FoxPro

Divers

Thread ID:

01244721

Message ID:

01244826

Vues:

>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

Répondre

Fil

Voir

Click here to load this message in the networking platform