我有一个f1数据库，我正试图将团队负责人的名字（从principals表）插入到teams表中，但由于某些原因它无法工作。我不确定我的insert into语句是否错了，但我不明白为什么会错。代码如下

CREATE TABLE Teams (
Team_Name VARCHAR(30) NOT NULL, 
Driver_1 INT NULL, 
Driver_2 INT NULL, 
Nation VARCHAR(30) NOT NULL, 
Seasons INT NOT NULL, 
No_Titles INT NOT NULL DEFAULT 0, 
Principal VARCHAR(30) DEFAULT NULL, 
PRIMARY KEY (Team_Name));
CREATE TABLE Principals (
Principal_No INT NOT NULL, 
Principal_Name VARCHAR(30) UNIQUE NOT NULL, 
Team VARCHAR(30) NULL, 
Age INT NOT NULL, 
Nationality VARCHAR(30) NOT NULL, 
Seasons INT NOT NULL DEFAULT 0, 
PRIMARY KEY (Principal_No), 
FOREIGN KEY (Team) REFERENCES Teams(Team_Name));

这是insert语句。主体表中已经填充了主体名称及其对应的团队

INSERT INTO Teams (Principal) 
SELECT Principal_Name 
FROM Principals 
WHERE Team IN(
    SELECT Team_Name 
    FROM Teams);