Re: [SQL] Query to match location transitions

2008-11-15 Thread Tomasz Myrta
sub3 napisal 14.11.2008 20:12: Hi, I was hoping someone could help me build a better query. I have a table of time/locations. Occasionally, we have multiple timestamps for the same location. I would like to remove those extra timestamps and only show the transition from one location to anothe

[SQL] Query to match location transitions

2008-11-14 Thread sub3
Hi, I was hoping someone could help me build a better query. I have a table of time/locations. Occasionally, we have multiple timestamps for the same location. I would like to remove those extra timestamps and only show the transition from one location to another. So... create table time_loca