UPDATE 
	STG_DEALS d 
	inner JOIN TBL_USER u 
	ON  u.user = d.user
SET d.user_id = u.id;