推 dcplay01:有沒有用AS 好像沒什麼很大的差別@@"..應該吧 @@ 01/24 17:37
※ 引述《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