Filtering without Group By and Having ? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Filtering without Group By and Having ?

Message

De

07/12/2001 16:08:24

Janis Booth
Webmd
Prospect, Connecticut, États-Unis

À

07/12/2001 13:22:36

Jay Van Santen
Indiana, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

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

Titre:

Re: Filtering without Group By and Having ?

Divers

Thread ID:

00590837

Message ID:

00591456

Vues:

32

Jay,

Your alternate query would work fine and give the correct results, but it would be slower because your subquery is doing an unnecessary join. I am sure that under certain circumstance the complex subquery would be required.

Janis

www.JamesBooth.com

Click here to load this message in the networking platform