title: nested SELECT in INSERT sql statement
body: <p>Can someone tell me why this doesnt work?</p>
  
  <pre><code>INSERT INTO Medical_History (pid, grafts, allergies,  diseases, surgearies, treatment)
  VALUES ((SELECT pid FROM Pet WHERE pet_name='Jack' AND cid=(SELECT cid FROM Customer WHERE last_name='Iwannidis' AND first_name='Giwrgos')),
         'grafts', 'allergies', 'diseases', 'surgearies', treatments');
  </code></pre>
  
  <p>I get a syntax error:</p>
  
  <pre><code>unrecognized token "');"
  </code></pre>