Complex Query

[wailingrecluse]

Hi guys, I'm hoping someone can help me with a fresh take on this.

I am trying to work out repeat call-backs going into an application, I have the first part of the query which shows returns the rows where the phone number appears in the app more than once within the same date.

the next part which has got me stumped is:

Each call has a start time, an initial callback time and an end time.
The start time of each call will dictate which is call 1 and which is call 2.

What I need to return is those where the start time of call 2 is greater than the initial callback time of call 1 and less than the end time of call 1.

can anyone help with this? My brain is fried!

thanks

 

[wailingrecluse]

Just in case anyone is interested, I figured this out by doing a count of phone number and then another query to do a count of the count and those were the numbers I was after.

thanks