Just use following Statement:

update table_1 as t1
inner join table_2 as t2 on t2.t1_id = t1.id
set
     t1.field = t2.field
Tags
Comments
Write the first comment
Leave a trace
Name *
Email *
Website
Anti SPAM * Code (9 + 4) =
Leave me a comment *
 
All comments are subject to editorial review
Post being viewed right now
Item date: 24.08.2009
Views: 314
Item date: 21.07.2009
Views: 2042
Item date: 23.08.2009
Views: 1952
Item date: 13.05.2009
Views: 436
Item date: 20.07.2009
Views: 1436
Item date: 22.08.2009
Views: 2075
Item date: 01.01.2009
Views: 1789
Item date: 24.08.2009
Views: 805
Item date: 01.01.2009
Views: 1836
Item date: 12.04.2009
Views: 1691