title: SQL Instead of insert trigger
body: <p>I have these tables:  </p>
  
  <pre><code>Aircraft(acID, acNAME, range)  
  Employee(empID, empNAME, salary)  
  Certification(empID, acID)  
  </code></pre>
  
  <p>And this view:</p>
  
  <pre><code>CREATE VIEW AircraftPilot AS
  SELECT empNAME, salary, acNAME, range
  FROM Employee e, Certification c, Aircraft a
  WHERE c.empID = e.empID AND c.acID=a.acID;
  </code></pre>
  
  <p>I have to create an instead of trigger to insert like this:</p>
  
  <pre><code>INSERT INTO AircraftPilot (empNAME, salary, acNAME, range) VALUES ('John', '3000', 'BOEING 737', '4500')
  </code></pre>