>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)
SELECT * ;
FROM Name_Addr ;
WHERE CustID NOT IN (SELECT CustId FROM Purchase) ;
INTO CURSOR cNoSale
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer