update (select * from scoreTable as s inner join project as

来源：学生作业帮编辑：大师作文网作业帮分类：英语作业时间：2024/11/20 06:51:09

update (select * from scoreTable as s inner join project as p on p.pid=s.pid ) as w set w.score=1 w
update (select * from scoreTable as s inner join project as p on p.pid=s.pid ) as w
set w.score=1 where w.sid=1 and w.pname='语文'
这个语句有错吗

这样写肯定有问题了因为update只能对物理表进行更新,而现在你是在更新子表,那就肯定有问题.不过按你的意思只要改一下就可以了：
UPDATE SCORETABLE
SET SCORE=1 WHERE SID=1 AND PNAME='语文'
WHERE PID IN(SELECT PID FROM PROJECT)

select s.name,s.course,s.grade from student as s inner join $sql="SELECT count(*) as pcount FROM news" 和$sql = "UPDATE a sql="select P.*,T.name as Typename from tb_function P inner $sql_notice = "select * from $t_article art inner join $t_ar select * from a,b与select * from a inner join b 的取数方式和执行效率有什么 select * from userinfo a inner join emp b on a.userinfoid li select * from tab_a inner join tab_b on tab_a.col1 = tab_b.c create table party_centification_bak as select * from party_ sql函数,select count(A.abc) as sum from A left join B on A.id= ms sql :select * from (select *from b) as xxx where 和 select select ···fromA join B on·····和select····from A inner join B SQL语句理解 select * from B where (select count(1) as num from A