title: Is there a query to join a many-to-many linked table into a single record?
body: <p>I have a standard many to many relationship between two tables, linked using a third linking table. Is there anyway to JOIN the linked ids into one record with a query?</p>
  
  <p>I realize I can process a typical join and build a new list with this, just wondering if it can be done with a query. Example:</p>
  
  <pre><code>EventID | EventName | EventTypeIDs
  
  1 | Party | 1,2,3
  
  Events
  +-------------+-------------+
  | Field       | Type        |
  +-------------+-------------+
  | EventID     | INT         |
  | EventName   | varchar(45) |
  +-------------+-------------+
  
  EventTypes
  +-------------+-------------+
  | Field       | Type        |
  +-------------+-------------+
  | id          | INT         |
  | value       | varchar(25) |
  +-------------+-------------+
  
  EventTypeLink
  +-------------+-------------+
  | Field       | Type        |
  +-------------+-------------+
  | id          | INT         |
  | EventID     | INT         |
  | EventTypeID | INT         |
  +-------------+-------------+
  </code></pre>