作者starjou (周星星)
看板Database
标题Re: [SQL ] UPDATE 用法?
时间Thu Jan 24 17:31:05 2008
※ 引述《Catbert (宅男)》之铭言：
: 上面的改成下面这段试试^^"
: UPDATE calculate
: SET liberal_grade=
: (
: SELECT avg(grade)
: FROM JoinClass j1 JOIN calculate c1 ON j1.stu_id = c1.stu_id
: WHERE course_id LIKE "%l" OR
: course_id LIKE "%a" OR
: course_id LIKE "%n" OR
: course_id LIKE "%p" AND
: j1.stu_id =93101163
: )
: 试试^^"
本板的重覆推文时间也隔太久了 XD
完整的语法是 FROM table1_name AS table1_alias JOIN table2_name AS table2_alias
ON table1_alias.field_name = table2_alias.field_name ...
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 219.80.137.188
1F：推 dcplay01:有没有用AS 好像没什麽很大的差别@@"..应该吧 @@ 01/24 17:37