title: How to determine if a 2nd service was done within 2 min of the other?
body: <p>How to determine if a 2nd service was done within 2 min of the other?</p>
  
  <p>Hi team I'm working on 2 tables an I need to determine if table1  service A was done within 2 min of table2  service B.</p>
  
  <p>And also  to determine how many  service B  did not have any service A here is example below!</p>
  
  <pre><code>TABLE 1
  ID.    Ser    Start.  End                
  Qw.    A     23May2016:00:34:00.     23May2016:00:40:00
  
  TABLE 2
  ID.    Ser    Start.  End               
  Qw.   B    23May2016:00:35:00.     23May2016:00:41:00
  </code></pre>
  
  <p> </p>
  
  <p>In the example table One open within 2 min of the 2nd service I would want to see table two in a dataset</p>
  
  <p>That's first part  here is 2nd part </p>
  
  <pre><code>TABLE 1
  ID.    Ser    Start.    End            
  Qw.    A     26May2016:00:29:00.     26May2016:00:40:00
  
  TABLE 2
  ID.    Ser    Start.     End                                  
  Qw.    A     26May2016:00:38:00.     26May2016:00:40:00
  </code></pre>
  
  <p>On this example what it's showing is there was a service B but no service A open up within 2 min I would want that on its own <strong>dataset</strong> .... thanks again  for help. Anyone?</p>