Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>Hi All -
>>
>>I am experiencing a bit of brain deadness this morning. I set out to write what I thought would be a rather simple SQL select statement but I just can't seem to get my head around it. Thus my plea for help. There are 2 tables CUSTOMERS and ORDERS. Common field is custID. I want to select all customers and the _date and amount of their most recent order (one record per customer). Can someone help me figure out how to do this?
>>
>>Thanks
>
>What DB you use?
>VFP - what version?
>SQL Server - what version?
>Other?
Hi Borislav - It's VFP 9.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement