title: Why is a semicolon expected in my SQL statement for inserting into two tables?
body: <p>I'm trying to insert two sets of data into my database and it gives me an error saying that it is missing a semicolon at the end of the SQL statement. </p>
  
  <p>Here is the code I've typed in:</p>
  
  <pre><code>procedure TForm9.Button1Click(Sender: TObject);
  var
  sNewTeam, sNewCountry : string;
  begin
        sNewTeam := InputBox('NEW','Insert The Name Of The New Team','',);
        sNewCountry := InputBox ('NEW','Insert The New Country','');
  
     qryAdmin.Active := false;
     qryAdmin.SQL.Text := 'INSERT INTO Teams(Teams) VALUES("'+sNewTeam+'")' + 'Country(Teams) VALUES("'+sNewCountry+'")';
     qryAdmin.ExecSQL;
  end;
  </code></pre>