真心求助,在线等 万分感谢,
帮我看一下这个Access, SQL为什么运行不了?
说是“number of query values and destination fields are not the same"
INSERT INTO Club
VALUES (1,'23 Pitt ST.Melbourne','Super man',2);
我的Club的结构是这样定议的
CREATE TABLE Club
(ClubID INTEGER NOT NULL PRIMARY KEY,
Address CHAR(50),
ClubName CHAR(30),
ClubManagerREgistrationID INTEGER NOT NULL,
Constraint clubmanager foreign key (ClubManagerRegistrationID) references Staff(RegistrationNo)
);