title: Insert data into nested tables SQLite in Air for Android
body: <p>I have three SQLite tables <code>Schools</code> <code>Classes</code> and <code>Students</code>. One <code>School</code> consists of multiple <code>Classes</code> and each <code>Class</code> in turn consists of multiple <code>Students</code>. </p>
  
  <p>On my application (Air for Android), I have some class structure like this</p>
  
  <pre><code>class School { id:uint; name:String; classArray:ArrayList}
  class Class { id:uint; name:String; studentArray:ArrayLisy}
  class Student { id:uint; name:String}
  </code></pre>
  
  <p>As the application is targeted at mobile platform, I would like to minimize the number of queries sent as much as possible. I'm new to SQL so at the moment I just loop through every elements, which is quite inefficient. Is there some kind of compound query or special keyword that can help achieve this.</p>
  
  <p>Thanks</p>