pgsql join update sample

pgsql join update sample

postgresql join update sample

update
	stock_day_chart
set
	std_prc = b.std_prc ,
	close_per = b.close_per ,
	high_per = b.high_per,
	fvrt_yn = b.fvrt_yn
from
	stock_day_chart_backup b
where
	(stock_day_chart.stock_cd = b.stock_cd
		and stock_day_chart.stock_date = b.stock_date)
	and
	b.std_prc is not null