title: How to delete master detail records using one sql?
body: <p>Using Delphi 7 and interbase 7  </p>
  
  <p>Is it possible to delete a master detail record and all of its nested detail records in one SQL statement?  </p>
  
  <p>Example:  </p>
  
  <p>Table1<br>
   ID - Integer<br>
   TITLE - Varchar(80)  </p>
  
  <p>Table2<br>
   ID - Integer<br>
   Table1_ID - Integer<br>
   TITLE - Varchar(80)  </p>
  
  <p>Table3<br>
  ID - Integer<br>
  Table2_ID - Integer<br>
  TITLE - Varchar(80)  </p>
  
  <p>I would like to delete ID 10 from Table1, and all of its matching records (Table1_ID) in table 2, and all its matching records (Table2_ID) in table 3  </p>
  
  <p>If i can't do this in one sql, how do i do it in multiple sqls (correct sequence to call statements)?</p>