title: Display Featured Records First Using JOIN/UNION
body: <p>I have the following data from a table:</p>
  
  <pre><code>ID  Name        IsFeatured
  1   Alpha       Yes
  2   Echo        No
  3   Delta       Yes
  4   Charlie     Yes
  5   Bravo       No
  </code></pre>
  
  <p>and I would like to display the featured records first, sorted in ascending order (name):</p>
  
  <pre><code>ID  Name        IsFeatured
  1   Alpha       Yes
  4   Charlie     Yes
  3   Delta       Yes
  5   Bravo       No
  2   Echo        No
  </code></pre>
  
  <p>I use the following query to combine two separated queries but it won't allow me to use ORDER BY twice.</p>
  
  <pre><code>SELECT ID, Name, IsFeatured FROM table1 WHERE IsFeatured='Yes' ORDER BY Name
  UNION ALL
  SELECT ID, Name, IsFeatured FROM table1 WHERE IsFeatured='No' ORDER BY Name
  </code></pre>
  
  <p>Any suggestions?</p>