Thread
:
MySQL Update / Join on match
View Single Post
12-28-2010, 01:06 PM
potter
Confirmed User
Industry Role:
Join Date: Dec 2004
Location: Denver
Posts: 6,559
got it using:
UPDATE table_1 AS t1, table_2 AS t2
SET
t1.name = t2.name
WHERE t1.userid = t2.userid
__________________
potter
View Public Profile
Find More Posts by potter