title: UPDATE table based on query
body: <p>I have not used UPDATE before and I am trying to update a table based on a query of multiple tables. What I am trying to do is change the servicetype.servicetype_id from 1 to 74571 on the services returned in my query. When I execute the query below I get an error of "The-multipart identifier "service_1.service_id" could not be bound" and all the instances of the service table in my query change to service_1. </p>
  
  <pre><code>UPDATE service
  SET service.service_id = 74571
  FROM accountservice INNER JOIN
       serviceclass ON accountservice.serviceclass_id = serviceclass.serviceclass_id INNER JOIN
       service ON accountservice.service_id = service.service_id INNER JOIN
       servicetype ON service.servicetype_id = servicetype.servicetype_id
  WHERE        (servicetype.servicetype_id = 1) AND (serviceclass.serviceclass_id = 74561) AND (accountservice.fromdate &lt;= '2013-11-15') AND (accountservice.todate IS NULL)
  </code></pre>