title: SQL Join Tables
body: <p>Table one contains</p>
  
  <pre><code>ID|Name  
  1  Mary  
  2  John  
  </code></pre>
  
  <p>Table two contains</p>
  
  <pre><code>ID|Color  
  1  Red  
  2  Blue  
  2  Green  
  2  Black  
  </code></pre>
  
  <p>I want to end up with is  </p>
  
  <pre><code>ID|Name|Red|Blue|Green|Black  
  1  Mary Y   Y  
  2  John     Y     Y     Y
  </code></pre>
  
  <p>Thanks for any help.</p>
  
  <hr>
  
  <p>Thanks for the responses. I'm going to re-post this with some additional info about exactly what I'm trying to do that may complicate this. Can someone close this?</p>