SQLite Forum

Nearest-match join
If a solution can be found that includes one row for each “nearest” timestamp, then those questions can easily be resolved by applying more filtering to the output, I think. In other words, those are questions that must be asked for any practical application, but they don't really influence the search for a solution much.