SQL Select query for the mentioned condition : <p>There are two tables <strong>A</strong> and <strong>B</strong>.</p>

<p>A has two columns <strong>account_id</strong> and <strong>ad_id</strong>. 
There are multiple <strong>ad_id</strong> for each <strong>account_i</strong>d.  </p>

<p>Table B has multiple columns including  and ad_id.  </p>

<p>I need to fetch all the <strong>ad_id</strong> for <strong>account_id=100</strong> then for all these <strong>ad_id</strong> I need to delete the data from <strong>table B</strong></p>

<p>I need Help with the SQL query for the same.</p>
