Copies a column from a given table to another column of another table

I'm trying to do this update, but I'm having trouble since I'm grateful for the help !!

UPDATE pctabpr set pctabpr.ptabela = (SELECT ptabela 
                                      FROM pcembalagem 
                                      WHERE pcembalagem.codprod = pctabpr.codprod);

What's wrong?