title: Check value in rows with same FK
body: <p>I have the table below</p>
  
  <pre><code>ID  | PARCEL  | STATUS  | ORDER_ID
  1     1         COMPLETE     1234
  2     2         COMPLETE     1234
  3     1         COMPLETE     9999 
  4     2         PENDING      9999   
  5     3         PENDING      9999
  6     1         COMPLETE     1111
  7     2         COMPLETE     1111
  8     3         COMPLETE     1111   
  9     1         COMPLETE     3333 
  10    2         PENDING      3333 
  </code></pre>
  
  <p>I need select the order_id with ALL PARCEL's having a COMPLETE status.</p>
  
  <p>i am trying with select, but don't work </p>
  
  <pre><code>SELECT * FROM table WHERE order_id NOT IN 
  (SELECT order_id  FROM table WHERE status = 'COMPLETE'); 
  </code></pre>
  
  <p>the answer for the query is</p>
  
  <pre><code>ID  | PARCEL  | STATUS  | ORDER_ID
  1     1         COMPLETE     1234
  2     2         COMPLETE     1234
  6     1         COMPLETE     1111
  7     2         COMPLETE     1111
  8     3         COMPLETE     1111   
  </code></pre>