in reply to Perl and Mysql compare 2 tables

UPDATE syntax in different from SELECT syntax.
Try something like
...
UPDATE Table2 SET value2 =
...

jbt

In Section Seekers of Perl Wisdom