Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP8 GROUP BY Restriction
Message
From
30/05/2003 03:22:33
Walter Meester
HoogkarspelNetherlands
 
 
To
28/05/2003 18:53:46
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00793077
Message ID:
00794386
Views:
11
Tamars example rewritten,
SELECT Customer_id, Order_no, Order_date ;
	FROM Orders ;
	WHERE DTOC(DATE())+STR(order_pk) IN (;
		SELECT MAX(DTOC(DATE())+STR(Order_pk)) FROM ORDERS GROUP BY Customer_id)
Walter,
Previous
Reply
Map
View

Click here to load this message in the networking platform