Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Converting to VFP9 SQL
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Converting to VFP9 SQL
Divers
Thread ID:
01005624
Message ID:
01005624
Vues:
65
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform