How can I use Join On for update data on sql php?

Question

I have 2 tables.

Table 1 named: Users

Rows:

Table 2 named: Data

Rows:

I need UPDATE the row Data on Users with the Data3 of table Data when on table Data the row Data1 = YES To the username with the Data1 = Yes.

I have this:

UPDATE Users JOIN Data ON Data1 = 'Yes' SET Data = Data3 WHERE Name_Data = Name_Users

I try others but nothing work, Is possible do it?, thanks

Which dbms are you using? (That syntax is product specific.) — jarlh, Oct 04 '18 at 09:41
Check this post https://stackoverflow.com/questions/9894353/update-query-with-inner-join-between-tables-in-2-different-databases-on-1-server — Ram, Oct 04 '18 at 09:43

score 1 · Accepted Answer · answered Oct 04 '18 at 09:44

1

i think you sql will be like below

   UPDATE Users u
   JOIN Data d ON d.Name_Data = u.Name_Users and d.Data1 = 'Yes' 
   SET u.Data = d.Data3

answered Oct 04 '18 at 09:44

1 Answers1