title: Inner Join Delete in SQL Server 2008?
body: <p>I am trying to join 2 tables together and do a delete on it.</p>
  
  <pre><code>DELETE TableA 
  FROM TableA a
  INNER JOIN
  TableB b on b.Id = a.Id
  where title like 'test' 
  </code></pre>
  
  <p>The above is what I come up with however I keep getting </p>
  
  <blockquote>
    <p><em>The DELETE statement conflicted with the REFERENCE constraint</em></p>
  </blockquote>
  
  <p>I thought if I merge the 2 tables together then I will delete both at the same time and no constraints would be conflicted. </p>
  
  <p>Am I missing something in my query?</p>