title: Select Top 1 from one table and all linked values from another in SQL
body: <p>I have two tables </p>
  
  <p>Table <code>Tbl_Headline</code></p>
  
  <pre><code>ID_key
  News_Type
  </code></pre>
  
  <p>Table <code>Tbl_Item</code></p>
  
  <pre><code>Item_ID
  ID_key
  </code></pre>
  
  <p>I need to get the top 1 from <code>Tbl_Headline</code> but all the <code>Item_ID</code>'s from the second table that match on that <code>ID_key</code> in one query</p>
  
  <p>Probably code 101 but I'm having a mental block</p>
  
  <p>Thanks for any help</p>