title: Inner select on one to many
body: <p>I have 2 tables event + event_artist</p>
  
  <h2>event</h2>
  
  <pre><code>eventId | eventName  
  -------------------
  1 , gig1  
  2, gig2    
  </code></pre>
  
  <h2>event_artist</h2>
  
  <pre><code>eventId, artistName 
  ------------------- 
  1, Led Zip  
  1, The Beatles  
  </code></pre>
  
  <p>ie Led Zep and the Beatles are both playing @ Gig1</p>
  
  <p>I need to create the SQl to bind to a gridview ( you necessarily need to know about gridviews to answers this )</p>
  
  <p>The results that i want would look like this<br>
  eventId = 1, EventName = Gig1. ArtistLineup = Led Zep, The beatles</p>
  
  <p>So i need to create an alias ArtistLineup that would list all the artist. Via an inner select i think.</p>
  
  <p>Any thoughts on what this would look like. </p>