Update data in one table to another?

[mikeyca]

Hello, I have been confused on how I can do this.

 

I have 2 tables in the same database. 

users & pollcomments

 

In the users & pollcomments both have a userid and username field.

 

I need to populate the username data from the users table into the pollcomments table if the userid in the pollcomments field equals the userid field in the users table. 

 

The poll table is populated and does contain the userid data, but currently the user field is blank for all the data in the table.

 

Thanks,

mikey

 

mysql: 4.1.20

 

[Gamic]

update pollcomments
set username = u.username
from pollcomments p
inner join users u
	on p.userid = u.userid