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


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.htm
Received on Thu Mar 30 2000 - 00:00:00 CEST

Original text of this message