title: Delete multi table without join
body: <p>I have two tables T1 and T2. C1 is the primary key of T1, C2 is a foreign key of T2 that references the column C1 of T1. I want to delete the rows of T2 that verify a particular condition. A simple DELETE can be used :</p>
  
  <pre><code>DELETE FROM T2 WHERE &lt;condition&gt;;
  </code></pre>
  
  <p>But, I also want to delete the rows of T1 that are related to the rows deleted by the previous statement. For example, if the row R2 (of T2) has been deleted by the previous statement, I also want to delete the row R1 (of T1) with a primary key referenced by R2.
  I know that there is a possibility to use DELETE statements with JOIN, but I use an HSQLDB in-memory database that doesn't support this feature.</p>