UPDATE salary_detail
SET salary_detail.s_card = employer.s_card
FROM salary_detail, employer
WHERE salary_detail.static_no = employer.static_no AND salary_detail.s_card <> NULL 其中employer 与 salary_detail 是一对多的关系
SET salary_detail.s_card = employer.s_card
FROM salary_detail, employer
WHERE salary_detail.static_no = employer.static_no AND salary_detail.s_card <> NULL 其中employer 与 salary_detail 是一对多的关系
SET s_card = employer.s_card
FROM salary_detail, employer
WHERE salary_detail.static_no = employer.static_no
AND salary_detail.s_card is not NULL
SET s_card = e.s_card
FROM salary_detail s, employer e
WHERE s.static_no = e.static_no AND s.s_card is not NULL
两者是不同的。