Update Join - Heeyoung-Ahn/MariaDB-with-Excel-VBA GitHub Wiki
Update Join
UPDATE currencies_monthly a
INNER JOIN co_account.currencies b
ON a.currency_id = b.currency_id AND a.refer_dt = b.refer_dt
SET a.fx_rate_krw = b.fx_rate_krw, a.fx_rate_usd=b.fx_rate_usd
WHERE a.refer_dt = '2019-01-31'