更新组合起来的表的内容,提示错误。我上代码,各位帮忙改下,谢谢!
update (select Course.*,Colleges.*,Majors.*,ClassTime.*,ClassAddress.*
from Colleges,Majors,Course,ClassTime,ClassAddress
where Course.Course_college=Colleges.co_no
and Course.Course_major=Majors.Ma_no
and Course.Course_time=ClassTime.Time_no
and Course.Course_address=ClassAddress.Address_no)
set Address_state=0 where Course_no='KC0001'
update (select Course.*,Colleges.*,Majors.*,ClassTime.*,ClassAddress.*
from Colleges,Majors,Course,ClassTime,ClassAddress
where Course.Course_college=Colleges.co_no
and Course.Course_major=Majors.Ma_no
and Course.Course_time=ClassTime.Time_no
and Course.Course_address=ClassAddress.Address_no)
set Address_state=0 where Course_no='KC0001'
set Address_state=0
from Colleges,Majors,Course,ClassTime,ClassAddress
where Course.Course_college=Colleges.co_no
and Course.Course_major=Majors.Ma_no
and Course.Course_time=ClassTime.Time_no
and Course.Course_address=ClassAddress.Address_no
and Course_no='KC0001'
update后面括号里的是组合起的新表
select Course.*,Colleges.*,Majors.*,ClassTime.*,ClassAddress.*
from Colleges,Majors,Course,ClassTime,ClassAddress
where Course.Course_college=Colleges.co_no
and Course.Course_major=Majors.Ma_no
and Course.Course_time=ClassTime.Time_no
and Course.Course_address=ClassAddress.Address_no
select (case when Course_no='KC0001' then 0 else Address_state end) as Address_state,
--下面查询的列中,去掉 Address_state 列
Course.*,Colleges.*,Majors.*,ClassTime.*,ClassAddress.*
from Colleges,Majors,Course,ClassTime,ClassAddress
where Course.Course_college=Colleges.co_no
and Course.Course_major=Majors.Ma_no
and Course.Course_time=ClassTime.Time_no
and Course.Course_address=ClassAddress.Address_no