sql query

[Peter]

Hello,

Lets suppose I have a table like this one

id id_1 id_2 date_time
1 101 1000 2006-07-04 11:25:43
2 102 1001 2006-07-04 11:26:43
3 101 1005 2006-07-04 11:27:43
4 103 1000 2006-07-04 11:25:43

I want to find all id_2 that has same id_1 and time difference in
records is no more than 5 minutes ...

I hope I explain well

In this case this is record 1 and record 3.

How can I do this ?

Thanks in advance for your help.

Peter
Send instant messages to your online friends http://uk.messenger.yahoo.com