The query looks okay, but where did you get the mysql_query from? It looks suspiciously much like PHP. If you are used to PHP, you should get aquainted with DBI which is the major perl-way of talking to databases.

Also, even if you may be able to use the mysql_-prefixed functions (using some odd perl module that I am not aware of), I am sure it shouldn't read mysql_ftech_array.

Finally, assigning string values require that you quote them:

$updatetable2= UPDATE Table2.value2 SET Table2.value2 =(@Table1.value)
[download]

Probably should read:

$updatetable2 = "UPDATE Table2.value2 SET Table2.value2 =(" . $row[0] 
+.")";
[download]

(@Table1.value is a mix of perl and JavaScript syntax and wouldn't work in either one of them.)

Consider spending a little time looking at the manual page for DBI and see how you can access databases there.