Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using a HAVING in view builder
Message
From
25/03/2003 16:43:33
Gary Foster
Pointsource Consulting LLC
Chanhassen, Minnesota, United States
 
 
To
25/03/2003 15:17:24
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00769877
Message ID:
00769953
Views:
17
The SQL code is pretty easy, it's making the view builder do it that's the rub. I'm hoping that I'm just overlooking something obvious. I tried typing it into the SQL window and reverse engineering it into the builder, but no such luck.

Gary

>I'm not familiar with view designer but writing something in code I'd write something like this:
>
>
>select c.*, count(*) as cnt from customer c group by customer_id having cnt > 2
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform