SQL: ORDER BY clause is invalid

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

SQL: ORDER BY clause is invalid

Message

01/04/2005 12:57:14

01/04/2005 12:46:58

Information générale

Forum:

Visual FoxPro

Catégorie:

Autre

Titre:

Versions des environnements

Visual FoxPro:

VFP 9

OS:

Windows XP SP2

Network:

Novell 5.x

Database:

Visual FoxPro

Divers

Thread ID:

01000629

Message ID:

01000740

Vues:

>>>>>
>
>To SQL server it's valid. IOW with a sample from pubs:
>
>

>select distinct au_fname,au_lname, phone, right(phone,4) as PhoneNo
>  from Authors
>  order by PhoneNo,Phone
>

is valid.
>Cetin

So Microsoft is being pretty inconsistent here.

Regards,

Jim