title: How to select a single record in a left join
body: <p>I need to select a specific model from the Models table using its key ModelID. I also need to add a blurb of content from the Model_Content table. The Models_Content table, however, has several blurbs of content for each model. I need to select just the first blurb.</p>
  
  <p>My tables look like this:</p>
  
  <pre><code> Models // table
   ModelID // pk
   Model // varchar
  
   Models_Content // table
   ContentID // pk
   ModelID // fk
   Content // varchar
  
   SELECT M.ModelID, M.Model, C.Content
   FROM   Models M LEFT JOIN Models_Content C ON M.ModelID =  C.ModelID
   WHERE      M.ModelID = 5
  </code></pre>
  
  <p>How do I adjust my query to select just the very first blurb of content for a specific model?</p>