Need comand sql ?

[DeYaN. 7]

what i want to do :

i have 2 tabbles account, i want to set at the first tabble the password for the secondary tabble,but only where in first tabble exist the password ='x'

 

I try this command , but function "  where password='x' " is wrong.

UPDATE account P1 where password='x'
    JOIN account2 P2
       ON P1.login = P2.login
SET P1.password = P2.password

 

 

Sorry for my english

[DeYaN. 7]

I solve the problem , thx you Guy 

 

" update account P1 JOIN account2 P2 ON P1.login = P2.login set P1.password = P2.password where P1.password = 'x' "