title: MySQL Query with select and grouping
body: <p>I would like to select all of the client records that were submitted by 10 but not the client records where 20 was assigned as a representative.  So my desire result would be 2 total records selected for client 2 and 3. 4 is excluded because 20 is part of that set.  Any help is greatly appreciated.</p>
  
  <pre><code>+--------------+--------+----------------+
  | Submitted_By | Client | Representative |
  +--------------+--------+----------------+
  |           10 |      2 |             15 |
  |           10 |      2 |             16 |
  |           10 |      2 |             17 |
  |           10 |      3 |             15 |
  |           10 |      3 |             16 |
  |           10 |      3 |             19 |
  |           10 |      4 |             15 |
  |           10 |      4 |             16 |
  |           10 |      4 |             17 |
  |           10 |      4 |             20 |
  +--------------+--------+----------------+
  </code></pre>
  
  <p>Tried </p>
  
  <pre><code>SELECT
      Client,
      Submitted_By,
      Representative,
  FROM
      client
  WHERE
  Client = 10 AND Representative != 20
  </code></pre>