title: Update statement in sql server 2005
body: <p>Consider the following Dig, Assume that all the three tables have a column <strong>Is_Deleted</strong> by default it is set to <strong>0</strong>... I want to update <strong>Is_Deleted=1</strong> field of <strong>Customers</strong> table where <strong>CustId=2</strong> only when the rows containing <strong>CustId=2</strong> and <strong>Is_Deleted=1</strong> in <strong>Orders</strong> and <strong>OrderItems</strong>
  Tables... I dont want to use <strong>Cascade</strong> option.. Any suggestion</p>
  
  <p><a href="https://i.stack.imgur.com/wQlr0.gif" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wQlr0.gif" alt="alt text"></a><br>
  <sub>(source: <a href="http://i.msdn.microsoft.com/ms152507.75c9e4c3-260d-4b8d-8a27-b720d8f4470e(en-US,SQL.90).gif" rel="nofollow noreferrer">microsoft.com</a>)</sub>  </p>