title: How to select all records in Table A that are not referenced for specific record in Table B
body: <p>I am trying to select all data belonging to playlisticons table except for data that user Tom also have in playlist table.</p>
  <p>Edit: I also have other users in the playlist table and hence I only want to return all playlisticons except for those that user Tom already have.</p>
  <p>My code looks something like this:</p>
  <pre><code>    
  SELECT 
  playlisticons.name
  ,playlisticons.link 
  FROM 
  playlisticons 
  LEFT JOIN playlist ON 
   playlisticons.name != playlist.icon WHERE playlist.userFK = 'Tom';
  
  </code></pre>
  <p>playlisticons.name and playlist.icon shares the same value
  playlisticons:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>name</th>
  <th>link</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Heart</td>
  <td>link1</td>
  </tr>
  <tr>
  <td>Bookmark</td>
  <td>link2</td>
  </tr>
  <tr>
  <td>Like</td>
  <td>link3</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>playlist:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>playlistID</th>
  <th>name</th>
  <th>userFK</th>
  <th>icon</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>Favourite</td>
  <td>Tom</td>
  <td>Heart</td>
  </tr>
  <tr>
  <td>2</td>
  <td>Watchlist</td>
  <td>Tom</td>
  <td>Bookmark</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Current output:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>name</th>
  <th>link</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Heart</td>
  <td>link1</td>
  </tr>
  <tr>
  <td>Bookmark</td>
  <td>link2</td>
  </tr>
  <tr>
  <td>Like</td>
  <td>link3</td>
  </tr>
  <tr>
  <td>Like</td>
  <td>link3</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Expected output:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>name</th>
  <th>link</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Like</td>
  <td>link3</td>
  </tr>
  </tbody>
  </table>
  </div>