title: SELECT WHERE related record's values have no occurrence
body: <p>I have a <code>Client</code> table and a <code>Devices</code> table.</p>
  
  <p>A client can have more than one device and a client has an active state as does the device.</p>
  
  <p>I want all the clients that are active but have no active devices.</p>
  
  <p>I INNER JOINED the devices on the clients for all the active clients, thus clients occur more than once, but now I don't know how to select all the clients that have no active device.</p>
  
  <p>This is how my relationships are set up:</p>
  
  <p><strong>Client</strong>:</p>
  
  <pre><code>pkClientID   Name     IsActive
  ------------------------------
  1            Jake     1
  2            Philip   1
  </code></pre>
  
  <p><strong>Device</strong></p>
  
  <pre><code>pkDeviceID  fkClientID  DeviceName  IsActive
  ---------------------------------------------
  1           1           Samsung     1
  2           1           Apple       0
  3           2           Samsung     0
  4           2           Sony        0
  </code></pre>
  
  <p>Since I already have all the active clients how do I select only Philip since he is active but has no active devices?</p>