|
Hello
I'm using Paradox.
I want to achieve the following effect:
Select into temp
distinct a.forcode, a.comp from dockets a
where a.docketdate > '31/03/2001';
Delete from dockets b
where not exists
(select c.forcode from temp
where b.forcode = temp.forcode
and b.comp = temp.comp)
BUT with Paradox I can't use the "into temp"
syntax
Can someone suggest another way of acheiving the
same.
In a nutshell, I want to delete all the rows from the dockets
table where the forcode/comp combination is not current (ie been used this
financial year)
Any ideas?
TIA
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:20010525T234629Z END:VCARD
