title: SQL INSERT INTO with SELECT and INNER JOIN
body: <p>I hope you can help me with this little problem. I am not quite sure of how to explain the situation to you, so I will just give it a try.</p>
  <p>What I am trying to do is the following:</p>
  <p>I want to insert some specific values and parameters (which I type in myself) into the table RFC_Risks, so basically every time I find a specific reason inside the table RCF_Risks, I want to write a new row that updates the priority of the RfC, every time that happens, the position shall be increased by 1.</p>
  <p>My problem is now, that when I run this statement, I just get the SELECT part :-), not inserting is done, neither do I get a SQL statement error or anything like that. I just type in the parameters and then I get a <code>SELECT</code> Table thats all.</p>
  <p>I'm using MS Access 2010 and I hope you can help me out with my &quot;little&quot; problem.</p>
  <pre><code>INSERT INTO RFC_Risks (RFC_No, RiskPos, Datum, Comments, RiskPrio, Reason)
  SELECT RFC_Risks.RFC_No, (RFC_Risks.RiskPos +1) AS RiskPos, [Aktuelles Datum] AS Datum, [Kommentartext] AS Comments, [Neue Prio] AS RiskPrio, RFC_Risks.Reason 
  FROM RFC_Risks INNER JOIN Risk_Reasons ON RFC_Risks.Reason = Risk_Reasons.Reasontext 
  WHERE RFC_Risks.Reason = Risk_Reasons.Reasontext;</code></pre>