RE: table join with itself

From: milmus (anonymous_at_discussions.microsoft.com)
Date: 03/02/04 

Date: Tue, 2 Mar 2004 12:36:06 -0800

Hi Rob,

i think you did not understand my problem. Therfore I will
post an example:

myTable
id | value
1 | 23
2 | 21
4 | 15
7 | 44

wishedResult
a.id | a.value | b.value (value of the record before)
1 | 23 | NULL
2 | 21 | 23
4 | 15 | 21
7 | 44 | 15

milmus