UPDATE Query Copy Field To Another Table

Hi all,

I have two tables and one of them (table1) has two fields called
pct_id and pct_name.
table2 has the field pct_id.

I also created a new field in table2 called pct_name.
What i'd like to do is set table2.pct_name=table1.pct_name wherever
table1.pct_id=table2.pct_id automatically.

Is there a query that can check to see if its the same and update table2?

Heres what i tried but it didnt work


UPDATE table1
SET table1.pct_name=table2.pct_name
WHERE ((table1.pct_id)=(table2.pct_id));

Thanks in advance