title: Complex insert statements
body: <p>I want to ask is it possible to insert your own value in the table as well as select other values in other table? I have tried to come out with my select and insert statement but i'm missing one statement as i want to insert my own values in rather than referencing it.</p>
  
  <p>All my required tables  have been created. And I wish to insert my own values like Type and rest of the insert values will be selected from other tables.</p>
  
  <p>Below is my code: (Am i missing a statement?)</p>
  
  <pre><code>Insert Into Test (Test_Date, Testno, Examno, Serialno, Type, Hours)
  Select S.Test_Date, E.Testno, S.Examno, S.Serialno, Type, (F.STARTED- F.ENDED) as hours
  From Semester S, TIME F, TESTPAPERS e
  Where S.Testno = F.Testno
    And E.Testno = 1
    and TYPE     = 'Non-FLight'; -- this is the statement that i wish to insert own values instead and not selecting.
  </code></pre>
  
  <p>Is it possible to do all in one insert statement ? I don't wish to update my table so many times just to insert type value.</p>
  
  <p>Thanks</p>