Update using another table

[thoand]

Is it posible in MySQL to update a column from another table colum?

I have a new table where I want to update empty column/rows with the data from the old table

the new table rows match the old table rows.

I've been googled around on this, but cant find any answers.
I've tried this without any luck:

"UPDATE articles SET pubdate = SELECT Publisert FROM artikler"

can anyone help me please,

thanks in advance,
Thomas

[eoghain]

Did you try the MySQL webpage?

It describes it right there:

UPDATE items,month SET items.price=month.price WHERE items.id=month.id;

So for your query you'd write:

UPDATE articles, artikler
   SET articles.pubdate = artikler.Publisert
 WHERE ????

You didn't include any matching information so I can't tell you what that would be.

[thoand]

Yes I tried the manual, I was looking in the wrong places :-)
thanks

best regards,
Thomas