Hi Jeff,

Yes thanks that project is now completed. The last question I posted was merely a case of having stared at the problem too long and not being able...

Hi Jeff,

SessionType is on the Sessions table e.g. 'Test 1', 'Test 2' or 'Control'. I've tried to keep the test data simple-ish so have just included two SessionTypes ('Test'...

Thanks again Seth for your time.

I see why what I've done is not a derived tables but have completely failed to figure out how to do what I...

I did what Seth suggested and investigated using derived tables (which I think are also called in-line views?) I've never used these before so this was interesting.

So anyway, I...

Ah - just seen Seth's latest reply. Am now thinking about that. Thanks again Seth

I am getting somewhere with this slowly but it sure is painful.

I set up my simple experiment with the tables:

SessionId Name ...

Hi guys,

Thanks very much for the replies. Very much appreciated. It's very good to know I'm no barking up the wrong tree. Now I've just got to...