Re: [DUG]: Another SQL poser

[Neven MacEwan]

Mark   is "select into TableName" std SQL, I would have expected "Insert into temp select ...."   If not I could say its Paradox not SQL   Neven ----- Original Message ----- From: Mark Howard To: Multiple recipients of list delphi Sent: Saturday, May 26, 2001 11:46 AM Subject: [DUG]: Another SQL poser 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