title: Basic SQL query design issue
body: <p>I'm trying to create a query that would basically be the equivelant of this (does not work).</p>
  
  <pre><code>SELECT * FROM `categories` AS C AND
  SELECT * FROM `items` AS I AND
  SELECT COUNT(I.id) AS items AND
  SELECT SUM(I.price) AS price;
  </code></pre>
  
  <p>I am not using SQLServer, and I'm using PDO through PHP for database connectivity.</p>
  
  <p>Here's the tables.</p>
  
  <p><strong>Category</strong></p>
  
  <blockquote>
  <pre><code>+----+------------+
  | id |  Category  |
  +----+------------+
  |  1 | First_Cat  |
  |  2 | Second_Cat |
  +----+------------+
  </code></pre>
  </blockquote>
  
  <p><strong>items</strong></p>
  
  <pre><code>+----+----------+------+-------+
  | id | category | name | price |
  +----+----------+------+-------+
  |  1 |        1 | Foo  | 1.99  |
  |  2 |        1 | Bar  | 2.00  |
  |  3 |        2 | ooF  | 0.99  |
  |  4 |        2 | raB  | 1.99  |
  +----+----------+------+-------+
  </code></pre>
  
  <p>Based on these tables I would be expecting these query results:</p>
  
  <pre><code>+----+------------+-------+-------+--+
  | id |  category  | items | price |  |
  +----+------------+-------+-------+--+
  |  1 | First_Cat  |     2 | 3.99  |  |
  |  2 | Second_Cat |     2 | 2.98  |  |
  +----+------------+-------+-------+--+
  </code></pre>
  
  <p>Any help? </p>