Help with SQL - Update between tables

Here is what I am trying to achieve in sudo code:

update table1 set
table1.fname = table2.fname,
table1.lname = table2.lname
where table1.emplid = table2.emplid;

Now clearly this is wrong since it gives me an error, the error I get is "invalid identifier - table2.emplid"

In English what I want to do is set the fname and lname of table1 to that of table2 where the emplid's match

The column names given above are the actual column names, so I am fairly sure these are not reserved words which i know can cause this error, it must be my awful SQL

Thanks for any assistance Received on Tue Jun 26 2007 - 14:20:16 CDT