title: Combine multiple rows into one row
body: <p>I'm trying different JOIN queries, but I'm not getting result I'm looking for.</p>
  
  <p>I've got 2 tables:</p>
  
  <pre><code>Table 1: **StockItemShort**    
  
  ItemID  | Code          | Name    
   432724 | CK002-16-09   | Green Daisy Pearl Earrings
   432759 | CK002-16-149  | Emerald Crystal Centre Daisy Earrings  
  
  Table 2: **StockItemCatSearchValueShort**
  
  ItemID |    SearchValueID
  432724 |    388839
  432724 |    389061
  432724 |    390269
  432724 |    389214
  432759 |    388839
  432759 |    389051
  432759 |    390269
  432759 |    389214
  </code></pre>
  
  <p>I can't get result I'm looking for.</p>
  
  <p>I'd like to get following result:</p>
  
  <pre><code>ItemID  | Code  | Name  | SearchValueID | SearchValueID | SearchValueID | SearchValueID 
  432724  | CK002-16-09   | Green Daisy Pearl Earrings    | 388839    | 389061    | 390269    | 389214
  432759  | CK002-16-149  | Emerald Crystal Centre Daisy Earrings | 388839    | 389051    | 390269    | 389214
  </code></pre>