title: Getting error in SQL query using INNER JOIN
body: <p>I'm still learning the MySQl.
  This is the relational DBMS :</p>
  <pre><code>CUSTOMER (CustID, CustName, AnnualRevenue)
  TRUCK (TruckNumber, DriverName)
  CITY (CityName, Population)
  SHIPMENT (ShipmentNumber, CustID, Weight, Year, TruckNumber, CityName)
  </code></pre>
  <p>Now, I have to formulate for these two queries:</p>
  <blockquote>
  <ol>
  <li>Total weight of shipments per year for each city.</li>
  <li>Drivers who drove shipments to London but not Paris.</li>
  </ol>
  </blockquote>
  <p>These are the queries i have came up with:
  1.</p>
  <pre><code>select sum(s.weight), s.year , c.city
  from shipment s, city c
  INNER JOIN CITY
  on s.CityName = c.CityName
  </code></pre>