scott wrote:
>> 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...

Out of curiosity... does this work?

Post a reply to this message