Hazelfresh Live: [SQL] Update set value from value in another table

Wednesday, November 7, 2012

[SQL] Update set value from value in another table

Code:

UPDATE tableB t1 
        INNER JOIN tableA t2 
             ON t1.id = t2.id
SET t1.name = t2.name 
WHERE t2.name = 'Joe'

1 comment:

AnonymousNovember 14, 2012 at 7:45 AM
What i don't realize is if truth be told how you're now not actually much more neatly-preferred than you
may be right now. You are so intelligent.
You understand thus significantly with regards
to this matter, produced me in my opinion consider it from numerous various angles.
Its like women and men are not interested except it's something to accomplish with Lady gaga! Your individual stuffs outstanding. All the time handle it up!
Also see my webpage: banc De binary demo
ReplyDelete
Replies