Filtering without Group By and Having ? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Filtering without Group By and Having ?

Message

From

07/12/2001 16:08:24

Janis Booth
Webmd
Prospect, Connecticut, United States

To

07/12/2001 13:22:36

Jay Van Santen
Indiana, United States

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: Filtering without Group By and Having ?

Miscellaneous

Thread ID:

00590837

Message ID:

00591456

Views:

31

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