I am trying to do the following thing with an SQL database.

Let assume that I have 3 rows lokking like that :
ID Number number 2
120 10 15
121 17 25
121 26 29

when in second row I want to check first row for the value of 'number 2'.

I would like to know if there s a way to check that easily on SQL Server 2000 (through SQL) ?

Thanks for the answer