title: Delete from table where multiple fields match select subquery result from other table
body: <p>I want to delete an entry in a table where multiple fields match the results of another select subquery which takes data from another table.</p>
  
  <p>query : </p>
  
  <pre><code>DELETE FROM table1
  WHERE carriedby_circuit IN (SELECT
      circuit_id
  FROM table2
  WHERE circuit_name IN (SELECT
      t.sc_prod_service_id
  FROM table3 t));
  </code></pre>
  
  <p>So I want to modify the query in such a way that if <code>circuit_id</code> form <code>table2</code> is present in <code>carriedBY_circuit</code> or in <code>CARRIED_CIRCUIT</code> columns of <code>table1</code>. it should delete the row from <code>table1</code>.</p>