Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
UPDATE Stop_times stp
JOIN Start_times strt
ON strt.PROJECTid = stp.PROJECTid
AND strt.EMPLOYid = stp.EMPLOYid
SET stp.Project_Charge_Time = TIMEDIFF(stp.STOPdatetime, strt.STARTdatetime)
;
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.