Re: deleting old records from table without subquery

2003-07-01 Thread Egor Egorov
Rupert Stokoe <[EMAIL PROTECTED]> wrote: > > I'm having problems trying to construct a delete query > from a table. Below is a scaled down version of the > table > > host userdateid > - > mars john 27-6 1 > pluto dave 27-6 2 > venus

deleting old records from table without subquery

2003-07-01 Thread Rupert Stokoe
Hi, I'm having problems trying to construct a delete query from a table. Below is a scaled down version of the table host userdateid - mars john 27-6 1 pluto dave 27-6 2 venus jane 27-6 3 mars john 28-6 4 saturn