I want to transfer 3 values ​​from one table to another. I do this with three subqueries. Can I do this in one request? That is, do not write 3 subqueries?

UPDATE worker SET start = (SELECT em.start FROM employee em WHERE em.id = id); UPDATE worker SET end = (SELECT em.end FROM employee em WHERE em.id = id); UPDATE worker SET count = (SELECT em.count FROM employee em WHERE em.id = id);

    1 answer 1

     UPDATE worker SET (start, end, count) = (SELECT em.start, em.end, em.count FROM employee AS em WHERE em.id = id);

    See UPDATE syntax.