title: Trigger on update that updates one field if another changes to a certain value
body: <p>I would like to create a trigger on update. There are two tables involved, cylinder and jobs. When the statusId in the cylinder changes to a certain value say 2 it changes a flag field in both tables. The cylinder table is update quite frequently. I believe I need to check the inserted and deleted tables it see if the statusId field changes to my value of 2.</p>
  
  <p>Here are simple versions of my tables. They are related thru jobNumb</p>
  
  <pre><code>CREATE TABLE Cylinder (
      cylinderId int IDENTITY(1,1) PRIMARY KEY,
      jobNumb int NOT NULL,
      statusId int,
      flag int
  )
  
  CREATE TABLE Jobs (
      jobId int IDENTITY(1,1) PRIMARY KEY,
      jobNumb int NOT NULL,
      statusId int,
      reShip int,
      flag int
  )
  </code></pre>