> SELECT *
> FROM EventRecord AS X, EventRecord AS Y, EventRecord AS Z
> WHERE
>   X.ExperimentID = Y.ExperimentID AND
>   Y.ExperimentID = Z.ExperimentID AND
>   X.EventID = 0 AND
>   Y.EventID = 2 AND
>   Z.EventID = 1 AND
>   X.EventDateTime < Y.EventDateTime AND
>   Y.EventDateTime < Z.EventDateTime;
>
> Or similar. (It's been a while since I did SQL...)

Oh cool that helps a lot, I'm copying and pasting that to a file somewhere 
for reference, thanks.  I still need to order myself an SQL book...

I guess that's the sort of question they should ask you at an interview :-)

Post a reply to this message