title: Select only table that don't meet specific condition
body: <p>I have 2 table and i tried to get table 1 which contains Job_ID which has not finish the progress in table 2.
  Table 1. [Job]</p>
  
  <h2>Job_ID (key)    |GroupID</h2>
  
  <pre><code>1410        |    A  
  2309        |    B  
  3456        |    C  
  </code></pre>
  
  <p>Table 2. [Progress]</p>
  
  <h2>Job_ID          |Percent</h2>
  
  <pre><code>1410        |    10
  1410        |    50
  1410        |    60
  2309        |    50
  2309        |    100
  3456        |    100
  </code></pre>
  
  <p>Expected:</p>
  
  <h2>Job_ID (key)    |GroupID</h2>
  
  <pre><code>1410        |    A  
  </code></pre>
  
  <p>My SQL Query is: </p>
  
  <p><code>SELECT FROM Job,(SELECT DISTINCT * FROM Progress 
  WHERE Percent&lt;100) AS PGR
  WHERE Job.Job_ID = PGR.Job_ID</code></p>
  
  <p>But i still get this</p>
  
  <h2>Job_ID (key)    |GroupID</h2>
  
  <pre><code>1410        |    A  
  2309        |    B  
  </code></pre>
  
  <p>My logic was getting only Job_ID which has Percent &lt; 100 but i failed to find specific way in SQL in stackoverflow. Please help me in this case.</p>