INSERT INTO k9ti_combine_data_sale (subid, transactionid, sale_date, amount, product, refunded, payment_plan,installment_payment_count, paymentgateway, time, src, fname, lname, email, phone, state, country, utm_source, utm_medium, utm_campaign, utm_term, utm_content, subscribe_date) SELECT k9ti_successful_transactions.subid, k9ti_successful_transactions.transactionid, k9ti_successful_transactions.sale_date, k9ti_successful_transactions.amount, k9ti_successful_transactions.product, k9ti_successful_transactions.refunded, k9ti_successful_transactions.payment_plan, k9ti_successful_transactions.installment_payment_count, k9ti_successful_transactions.paymentgateway, k9ti_successful_transactions.time, k9ti_customers.src, k9ti_customers.fname, k9ti_customers.lname, k9ti_customers.email, k9ti_customers.phone, k9ti_customers.state, k9ti_customers.country, k9ti_subscribers.utm_source, k9ti_subscribers.utm_medium, k9ti_subscribers.utm_campaign, k9ti_subscribers.utm_term, k9ti_subscribers.utm_content, k9ti_subscribers.date FROM k9ti_successful_transactions LEFT JOIN k9ti_customers ON k9ti_customers.subid = k9ti_successful_transactions.subid LEFT JOIN k9ti_subscribers ON k9ti_subscribers.subid = k9ti_successful_transactions.subid WHERE k9ti_successful_transactions.successfultransactionid > 10122UPDATE k9ti_combine_data_sale SET refunded = refunded+199.00 WHERE transactionid = 'pi_3QuVZULfHk74BsmY0Wd3Zppa'