Jump to content
×
×
  • Create New...
  • 0

Need comand sql ?


DeYaN.

Question

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 :(

Link to comment
Share on other sites

  • Answers 1
  • Created
  • Last Reply

Top Posters For This Question

Popular Days

Top Posters For This Question

1 answer to this question

Recommended Posts

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.