Update table from the other field of the same table

hell yeah.. got some tips from stackoverflow about how to update record from the other record from the same table. here is my code:

 

update `tblname` as dudul, (select id,record2 from `air` where record3=’2014-06′) AS dudul2
set dudul.record1 = dudul2.record2
where dudul.record3=’2014-07′ and dudul.id=dudul2.id;

 

thanks so.

ref: http://stackoverflow.com/questions/45494/mysql-error-1093-cant-specify-target-table-for-update-in-from-clause