title: delete from table according to a conditon in sql
body: <p>I have tables xx_org , xx_people and xx_asg. the org_id is common between xx_asg and xx_org and asg_id is common between xx_people and xx_asg.</p>
  
  <p>Now i want those organizations to be deleted from xx_org whose org_id is not in xx_asg and the person id in xx_people who have a column value extra_info as 'ITEM_OTB'. </p>
  
  <pre><code>XX_ORG                 XX_PEOPLE                        XX_ASG
  
  ORG_ID                 PERSON_ID                        ASG_ID
  ORG_NAME               PERSON_NAME                      ASG_NAME
  LEGAL_ENTITY           PERSON_NUMBER                    ORG_ID
                         ASG_ID
                         EXTRA_INFO
  
  DELETE FROM XX_ORG WHERE 
  ORG_ID NOT IN (SELECT DISTINCT ORG_ID FROM XX_ORG);
  </code></pre>
  
  <p>How do i incorporate my second requirement in this one that is thsoe people from xx_person who do have extra_info as 'ITEM_OTB' , Those people's org ids should also be deleted </p>