title: Delete records From Multiple Table using where IN clause
body: <p>I want to delete data from 2 tables based on plan id which comes from the plan_temp table using WHERE IN .. I would be very grateful if you guys help me</p>
  <p><strong>this is my code now I want to make this a single query</strong></p>
  <pre><code>DELETE FROM plan WHERE id_plan IN(SELECT id_plan FROM plan_temp WHERE no=1184);
  
  
  DELETE FROM plan_temp WHERE id_plan IN(SELECT id_plan FROM plan_temp WHERE no=1184);
  </code></pre>