> OK, here we go. Using a sub-select, you can find the "previous" event in 
> the log something like this:
>
>   SELECT *
>   FROM EventLog X, EventLog Y
>   WHERE
>     X.ExperimentID = Y.ExperimentID AND
>     Y.Timestamp =
>     (
>       SELECT MAX(Timestamp)
>       FROM EventLog Z
>       WHERE
>       Z.ExperimentID = X.ExperimentID AND
>       Z.Timestamp < X.Timestamp
>     )

<snip>

> ...if that makes *any* sense at all?

I'll have to read and work through it some more for it to all make sense, 
but it does make me realise that almost anything I want to get from my data 
should be possible with SQL - something which I was not sure about at the 
start!

Post a reply to this message