title: SQL where clause on inner joins
body: <p>I am working with pgadminIII (postgreSQL)</p>
  
  <p>I have the following tables:
  Book,
  Publisher,
  OrderLine,
  ShopOrder.</p>
  
  <p>With the following SQL:</p>
  
  <pre><code>SELECT 
      Book.BookID AS "Book ID"
      ,Book.Title AS "Book title"
      ,SUM(OrderLine.quantity) AS "Number Ordered"
      ,ShopOrder.OrderDate AS "Order Date"
  FROM (((Book
  
  INNER JOIN OrderLine
  ON Book.BookID = OrderLine.BookID)
  
  INNER JOIN Publisher
  ON Book.PublisherID = Publisher.PublisherID )
  
  
  INNER JOIN ShopOrder
  ON OrderLine.ShopOrderID = ShopOrder.ShopOrderID)
  
  GROUP BY ShopOrder.OrderDate, Name, Book.BookID
  
  .
  </code></pre>
  
  <p>I would like to use this with a (<code>WHERE Publisher.Name = "Smith Smitheson"</code>)</p>
  
  <p>I dont know where to put it, or if im doing it right, any help please?</p>