I have a sqlite database with 2 tables. Table
a has a running list of events and the times they happened. Table
b has the start and finish of time each event.
How can I find the minimum event from table
a for each group defined in table
b? Schema is described in my SQLFiddle.
I'm trying to get a result like:
id1 id2 time event c1 d1 2 5 c1 d2 1.2 10 c1 d1 5 8.2