SQLite Forum

Nearest-match join
Login
Dear Experts,

I have two tables, both of which have a timestamp column.

I'd like to join them on the timestamp, but where there is no 
exact match I'd like to match with the nearest timestamp from the 
other table.

Is there any clever way to achieve this efficiently?


Thanks, Phil.