title: Check table with certain values in the other table
body: <p>I have two tables as shown below</p>
  
  <h2>EmpMaster</h2>
  
  <pre><code>empid firstName  lastName  lstatus
  1       Mark      Rowen      1
  2       John      Griffin    1
  3       Derick    Rose       1
  
  
  EmpPers
  ----------
  empPersSeq  empID   perTypeID   PersTypeValue
  1             1        1            Good
  2             1        2            Fair 
  3             1        3            Good 
  4             2        1            Fair
  5             2        2            Fair
  6             2        2            Fair
  </code></pre>
  
  <p>How do get list of all EmpIds from empMaster that doesnt have perTypeID=3 records in EmpPers Table?</p>
  
  <p>Thanks in advance</p>