Re: [SQL] Identifying obsolete values

2001-10-22 Thread Masaru Sugawara
On Wed, 17 Oct 2001 17:17:44 METDST Haller Christoph wrote: > I use the second table to identify the actual resp. obsolete ones within the first >table. > > DELETE FROM advncd_tempreftime; > INSERT INTO advncd_tempreftime > SELECT timepoint,mid,lid,sid,MAX(entrancetime) FROM advncd_onfvalue

[SQL] Identifying obsolete values

2001-10-17 Thread Haller Christoph
First of all, thanks to Philip Hallstrom for the quick reply. Consider the following tables CREATE TABLE advncd_onfvalue (timepoint DATETIMENOT NULL, midINTEGER NOT NULL,/* measurement id */ lidINTEG