You can join the two tables in your UPDATE
query (read about it in the documantation):
UPDATE `Table 1` t1
JOIN `Table 2` t2 ON t1.ID = t2.ID
SET t1.endtime = t2.starttime
2
solved Update Table1 From table 2
You can join the two tables in your UPDATE
query (read about it in the documantation):
UPDATE `Table 1` t1
JOIN `Table 2` t2 ON t1.ID = t2.ID
SET t1.endtime = t2.starttime
2
solved Update Table1 From table 2