Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP60- SQL
Message
De
09/07/1999 01:08:27
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00239266
Message ID:
00239275
Vues:
10
Very good! I just tested it and it works. Thank you again.

>SELECT * FROM Name_Addr WHERE CustID NOT IN (SELECT CustId FROM Purchase WHERE YEAR(Purch_Date)=YEAR(DATE())) INTO CURSOR curNoSales
>
>>The problem:
>>Write a SQL command to retrieve the name and addresses of all customers that HAVE NOT made purchases this year.
>>
>>Thank you in advance.
>>
>>Assume the use of the following tables:
>>
>>TABLE 1 = NAME_ADDR
>>CUSTID C(10)
>>NAME C(30)
>>ADDRESS1 C(30)
>>ADDRESS2 C(30)
>>CITY C(30)
>>STATE C(2)
>>ZIP C(9)
>>
>>TABLE 2 = PURCHASE
>>CUSTID C(10)
>>ITEMID C(10)
>>QUANTITY N(3)
>>AMOUNT N(9,2)
>>PURCH_DATE D(8)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform