怎样解决这个问题

[huayunfeng]

　内部测试表：TestInfo
TestID Stage TestName
1 S1 Logic Java
2 S1 HTML
3 S1 SQL
4 S1 C#/WinForms
5 S2 SQL Server
6 S2 .Net
7 S2 JavaScript
8 S2 Java
9 Y2 .NET
10 Y2 Java
　内部测试成绩表：TestScore
TestID Class StudentName Score
1 S1161 张良宝 80
1 S1161 刘宇 100
2 S1161 张良宝 60
2 S1161 刘宇 60
2 S1161 严琴 80
1 S1162 杨超 40
1 S1162 张立华 100
1 S1162 陈磊 80
1 S1162 张伟 60
2 S1162 杨超 60
2 S1162 张立华 80
2 S1162 陈磊 80
2 S1162 张伟 40
2 S1162 杨飞 100


编写SQL语句实现以下的要求：

S1162班学员“杨飞”， Logic Java内部测试成绩为80分，录入时遗漏，请编写SQL语句插入该记录；


谢谢大家的帮忙！

[113244]

和你一起等....

[让你望见影子的墙]

insert into TestScore 
select TestInfo. TestID,' S1162','杨飞',80
from TestInfo
where TestName ='Logic Java'

[lintf1986]

update TestScore set TestID=(select top 1 TestID from TestInfo
where TestName ='Logic Java'),Score=80
where Class='S1162' and StudentName='杨飞'

[sgtzzc]

insert into TestScore values('1','S1162','杨飞','80')