|
Hi all
I want to do the following: (in Paradox 7)
Select count(*) from SaleREF sr
where (sr.CustCode, sr.DestCode) in (select distinct (CustCode, DestCode) from CustDest) ie I want to count the number of times that a
CustCode/DestCode pairing that appears in the CustDest table also appears in the
SaleREF table.
How can I do this, please?
Mark
|
BEGIN:VCARD VERSION:2.1 N:Howard;Mark FN:Mark Howard ORG:Forest Production Systems Ltd TEL;WORK;VOICE:(07) 348 8177 TEL;CELL;VOICE:(021) 477564 TEL;WORK;FAX:(07) 348 8178 ADR;WORK:;;P.O.Box 5155;Rotorua LABEL;WORK;ENCODING=QUOTED-PRINTABLE:P.O.Box 5155=0D=0ARotorua EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20010514T220542Z END:VCARD
