New SQL: What's with the GROUP BY error? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

New SQL: What's with the GROUP BY error?

Message

From

25/11/2003 14:50:06

Steven Bennett
Louisville, Kentucky, United States

To

25/11/2003 13:38:37

Mark McCasland
Midlothian, Texas, United States

General information

Forum:

Visual FoxPro

Category:

Other

Title:

Re: New SQL: What's with the GROUP BY error?

Miscellaneous

Thread ID:

00853362

Message ID:

00853447

Views:

15

>Same answer applies. You have to include every field in the GROUP BY that is returned by Detail.* AND Codes.Desc

Right, I see that now. Quite a drag to articulate everything that Detail.* would mean in this legacy app so I'll opt for the SET ENGINEBEHAVIOR 70 strategy in this instance.

Thanks Mark,
Steven-

Click here to load this message in the networking platform