UPDATE table 1 with data from table 2

Asked

Viewed 25 times

-2

Good morning, I’m having some difficulties to take dice from one table and play to another. I already tried INNER JOIN and could not.

I have that data:

Table 1 = nft | Column = walletAdress

Table 2 = Ccounts | Column = Wallet

UPDATE nft SET nft.walletAddress = accounts.wallet FROM nft INNER JOIN accounts ON nft.account_id = accounts.id WHERE nft.account_id = teste

I would like to play the Wallet(table 2) dice to walletAdress(table 1) when account_id = id. However my code is giving error.

php sql database

  • Important you [Dit] your question and explain objectively and punctually the difficulty found, accompanied by a [mcve] of the problem and attempt to solve. To understand what kind of question serves the site and, consequently, avoid closures and negativities worth reading What is the Stack Overflow and the Stack Overflow Survival Guide in English. Whenever you edit a question, it goes to a reevaluation queue and the community decides via vote whether it is already ok for the site or not.

  • The comments extended and were moved to the chat - if someone wants to follow, just use the link provided.

No answers

Browser other questions tagged php sql database

You are not signed in. Login or sign up in order to post.