title: How to rollup multiple rows when Inner Joining two tables
body: <p>I am stuck with an SQL command where I am joinig two tables. I have two tables: a 'restaurant' table and a 'review' table. The relationship is many reviews to one restaurant. After joining the tables I have many reviews for each restaurant, hence I end up with many duplicates for each restaurant. All I need is to group the duplicate restaurant rows in order to output a restaurant one one time in the search results I have implemented. The code so far is:</p>
  
  <pre><code>SELECT a.Restaurant_Id, a.Restaurant_Name, a.Restaurant_Location, 
     a.Restaurant_Image, a.Restaurant_Thumbnail, a.Restaurant_Owner, a.Restaurant_Description
  FROM restaurant a INNER JOIN review b 
    ON a.Restaurant_Id=b.Restaurant_Id
  </code></pre>
  
  <p>What is the simplest way of grouping the duplicate restaurant entries (I don't need to output any data from the 'review' table, I have only joined it to the 'restaurant' table for the search function on my website)?</p>
  
  <p>I need the column data from the 'restaurant' table (as defined in the select statement above) in order to output the restaurant information on my website (as a list of restaurants). e.g.</p>
  
  <pre><code>Id  Name           Location    Image   Thumbnail   Owner   Description
  -------------------------------------------------------------------------------  
  10  Red Lion       Manchester                       8       A description...
  </code></pre>
  
  <p>Thanks</p>