title: SQL - Foreign Key Constraint Error with Update Statement
body: <p>I am Trying to update my table (product) columns - ProductID(FK) and ProductType(FK). These two column has relation with MProduct table's column MProductID(PK) and MProductType(PK).</p>
  
  <p>I am trying to update </p>
  
  <pre><code>ProductID       ProductType
  9999            11
  9999            12
  </code></pre>
  
  <p>But I got the following error </p>
  
  <pre><code>The UPDATE statement conflicted with the FOREIGN KEY constraint "FKHCR_MProduct".
  The conflict occurred in database "XXXX", table "dbo.MProduct".
  </code></pre>
  
  <p>I checked with MProduct table, It has all the valid records for look up. I can not change my Table Structure.</p>
  
  <p>I tried this Query too</p>
  
  <pre><code>Select ProductID,ProductType
  from dbo.Product P
  Left Join dbo.MProduct M on M.ProductID = P.ProductID
     and M.ProductType = P.ProductType
  where M.ProductType is null
     and M.ProductID is null
  </code></pre>
  
  <p>and there is No Output, means there is No Null Data Inside the Look up table.</p>