title: How do you make a condition on a column in one table apply to every instance of a primary key?
body: <p>I have a table called 'Artists' which has columns Artist_ID, Artist_Name, Artist_Genre and a table called 'Albums' with Artist_ID, Album_Id, Album_Name, ALbum_Number_Songs etc. </p>
  
  <p>I join these two tables via Artist_Id. Now I want to know all Artists who have never had an album with over 12 songs. 
  I have tried this:</p>
  
  <pre><code>SELECT Distinct Artist_Name
  FROM Artists
  INNER JOIN Albums
  ON Albums.Artist_ID=Artists.Artist_Id
  WHERE Album_Number_Songs &lt; 12
  </code></pre>
  
  <p>however this just checks all instances and output will be just on whether or not the album has &lt; 12 not the artist overall...does anyone know?</p>