title: SQL find exact record combination
body: <p>I have two tables, one with routes and one with order delivery data.</p>
  
  <p>I need to choose for each order exact route which has all shops in it, no more no less, order of shops is not important. If I don't have exact route, I don't want to join any route to that order.</p>
  
  <pre><code>RouteId    ShopId
  ------------------------------------
  1            111
  1            222
  2            111
  2            222
  2            333
  3            111
  3            222
  3            333
  3            444
  
  OrderId     ShopId
  ------------------------------------
  11           111
  11           222
  11           333
  12           111
  12           222
  13           111
  13           333
  </code></pre>
  
  <p>I want result set like this</p>
  
  <pre><code>OrderId     ShopId   RouteId
  ------------------------------------
  11           111        2
  11           222        2
  11           333        2
  12           111        1
  12           222        1
  13           111        NULL
  13           333        NULL
  </code></pre>
  
  <p>I have around 50k-100k orders so I don't want to use cursors or any other loop if not necessary.</p>
  
  <p>Any help is greatly appreciated.</p>
  
  <p>Zoran </p>