UPDATE 
temp_shawpon_loan_data
SET total_outstanding=total_outstanding_april
WHERE total_outstanding_april>0

UPDATE temp_shawpon_loan_data SET has_april=1 WHERE total_outstanding_april>0


update 
temp_shawpon_loan_purposes as a set a.loan_purpose_id=(
select b.id FROM mf_product_purposes As b where a.loan_purpose=b.name and b.id>108
)


UPDATE temp_shawpon_loan_purposes SET loan_purpose_temp_id=loan_purpose_id



UPDATE mf_member_information AS b 
SET b.member_name=(SELECT member_name FROM temp_shawpon_loan_data AS a
WHERE a.member_id=b.id)

UPDATE mf_member_information AS b 
SET b.spouse_name=(SELECT a.spouse_name FROM temp_shawpon_loan_data AS a
WHERE a.member_id=b.id)