Re: Help needed: Retrieve only rows where numbers are concurrent

Steve,

> I'm not entirely sure what you want. I guessed that "concurrent"
> meant consecutive, so you want slot_id values of N, N+1 and N+2.
> If that's what you want, David's query won't assure that - it will find
> trainer_id, room_id pairs with three different slot_id values.
>

You are right. I never would have guessed that "concurrent" meant "consecutive".

My solution also depends on the absence of duplicate rows in the input tables. I unconsciously assumed that as given. It's my tendency to think of tables as if they always represent relations...on good days, they usually do.

--
Regards,
    David Cressey