Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting to VFP9 SQL
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Converting to VFP9 SQL
Miscellaneous
Thread ID:
01005624
Message ID:
01005624
Views:
63
Converting VFP6 SQL to VFP9 SQL.

Assuming that there is a table called custname with three columns: custnum, address,ordernum. There is no unique key. When the folloing SQL was run in VFP6, the address associated with the max(ordernum) was returned. The address was not chosen at random. How do you code this SQL in VFP9?
select custnum, address, max(ordernum) from cust group by custnum
Thanks

Brenda
Next
Reply
Map
View

Click here to load this message in the networking platform