Problem with count(*) in sql select

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Problem with count(*) in sql select

Message

11/05/2007 13:03:47

11/05/2007 13:02:14

Information générale

Forum:

Visual FoxPro

Catégorie:

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

Titre:

Versions des environnements

Visual FoxPro:

VFP 9 SP1

Divers

Thread ID:

01224704

Message ID:

01224709

Vues:

>>The column MYCNT does not exist, it's created by aggregate function. As such it should be checked in HAVING clause.

>>...
>>HAVING MYCNT > 1
>>...
>>

>>
>
>Thank you very much.

You're welcome.

--sb--