Re: [GENERAL] help with sql query

2006-10-18 Thread Albe Laurenz
Richard Broersma Jr wrote: >> id id_1id_2 date_time >> 1101 10002006-07-04 11:25:43 >> I want to find all records have same id_1, but different id_2 and have >> difference in time less than 5 minutes. >> In this case this is record 1 and record 3. >> How can I do this ? > > I a

Re: [GENERAL] help with sql query

2006-10-17 Thread Richard Broersma Jr
> idid_1id_2 date_time > 1 101 10002006-07-04 11:25:43 > I want to find all records have same id_1, but different id_2 and have > difference in time less than 5 minutes. > In this case this is record 1 and record 3. > How can I do this ? I am sure that this will need some "tu