title: SQL statement: How to retrieve and display each user and the many items they purchase
body: <p>I want to retrieve and display 3 customers per page and also display all the items they have purchased.
  Currently, my sql statment below can retrieve 3 rows of result but are the same customer if they purchase 2 or more items. I know it is possible to get what I want with multiple sql queries but is it possible to do it in one query? Please suggest if you have an idea on how people usually does it. Thanks!</p>
  
  <pre><code>SELECT *
  FROM customers, item
  WHERE customers.customer_id = customers_item.customer_id
  LIMIT 0, 3
  </code></pre>
  
  <p>Database Table: Customers<br>
  - customer_id<br>
  - customer_name</p>
  
  <p>Database Table: Item<br>
  - item_id<br>
  - item_name</p>
  
  <p>Database Table: Customers_item<br>
  - customer_id<br>
  - item_id</p>