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