title: How to show collection of all values of a column in sql server 2014
body: <p>let say i have a table like below
   Food(FoodID,FoodName)
   Package(PackageID,PackageName,FoodID)</p>
  
  <p>When i do </p>
  
  <pre><code>SELECT P.PackageID,F.FoodName  FROM FOOD F inner join PACKAGE P on F.FoodID = P.FoodID
  </code></pre>
  
  <p>it returns data like following</p>
  
  <pre>
  PackageID      FoodName
  1              Mango
  1              Apple
  1              Tacos
  </pre>
  
  <p>but i want to get it like following</p>
  
  <pre>
  PackageID     FoodName
  1             Mango,Apple,Tacos 
  </pre>  
  
  <p>How to do it </p>