这是查询：
INSERT INTO qualification_lookup (variation,correct_qualification) SELECT (SELECT Qualification FROM student WHERE Qualification like 'A%'),'A-Level'
Msg 512,Level 16,State 1,Line 1 Subquery returned more than 1 value. This is not permitted when the subquery follows =,!=,<,<=,>,>= or when the subquery is used as an expression. The statement has been terminated.
解决方法
INSERT INTO qualification_lookup (variation,correct_qualification) select Qualification,'A-Level' from student where Qualification like 'A%'
