The select statement works, but the update below does not. Did I do it wrong?


SELECT j.emp, j.job, j.sow_code, j.emp_sow_price, s.pay_rate
FROM job j
JOIN employee e ON j.emp = e.emp_id
JOIN sow_pay s ON j.sow_code = s.sow_code AND e.piece_payrate = s.pay_grade;


UPDATE job
SET emp_sow_price = s.pay_rate
FROM job j
JOIN employee e ON j.emp = e.emp_id
JOIN sow_pay s ON j.sow_code = s.sow_code AND e.piece_payrate = s.pay_grade;

Sorry, i always figure it out after I've posted.

Below works.

UPDATE job j, employee e, sow_pay s
SET j.emp_sow_price = s.pay_rate
WHERE j.emp = e.emp_id AND e.piece_payrate = s.pay_grade
AND j.sow_code = s.sow_code AND j.emp_sow_price != s.pay_rate;