Might be advanced Update statement
From: Halvor Nyberg <hnyberg_at_eunet.no>
Date: 2000/03/30
Message-ID: <38E30D98.58691524_at_eunet.no>#1/1
5 1000 700 31-12-1899
Date: 2000/03/30
Message-ID: <38E30D98.58691524_at_eunet.no>#1/1
Challenge:
I have a table like this:
Pos Parent Child ExpiredDate Info
1 1000 401 31-12-1899 U 2 1000 500 30-03-2000 3 1000 500 31-12-1899 U 4 1000 700 30-03-2000
5 1000 700 31-12-1899
In this example Pos 2 and 3 both contains Parent 1000 and Child 500. Pos
2 has Expired
(Date<>31-12-1899).
What i need is a SQL Update statement which Sets INFO of the Not Expired row equals INFO of the expired row WHERE INFO = U.
-- Regards Halvor A great Oracle tool: http://members.tripod.com/easydoc/dim.htm http://members.tripod.com/Nybbies/vb.htmReceived on Thu Mar 30 2000 - 00:00:00 CEST