UPDATE t_purchase_entry_main
INNER JOIN t_purchase_entry_main_temp on t_purchase_entry_main_temp.p_invoice_no = t_purchase_entry_main.p_invoice_no
SET t_purchase_entry_main.actu_inv_no = t_purchase_entry_main_temp.actu_inv_no;


UPDATE t_purchase_entry_main
INNER JOIN t_purchase_entry_main_temp on t_purchase_entry_main_temp.p_invoice_no = t_purchase_entry_main.p_invoice_no
SET t_purchase_entry_main.actu_inv_no = t_purchase_entry_main_temp.actu_inv_no, t_purchase_entry_main.financial_id = t_purchase_entry_main_temp.financial_id ;