UPDATE temp3 a
INNER JOIN temp2 b
ON a.batch_id = b.batch_id
and a.batch_li = b.batch_li
SET
a.comments = b.comments
WHERE
b.comments is not null;