title: How to insert data to two tables on relationship with unknown PK of first table?
body: <p>for example if we have to tables:</p>
  
  <pre><code> *table_auther:
   a_id : INT PK
   a_name: varchar(50)
  
  *table_books:
   b_id : INT PK
   b_name: varchar(50)
   a_id : INT FK
  </code></pre>
  
  <p>How to insert data of auther and his one or more books ,if I don't know the auther <code>a_id</code> what will be. what's the statement should be?</p>