数据库两张表字段替换

1.将P_GATEWAY中的名字字段，换成P_ROUTE中的ID

UPDATE P_GATEWAY
SET P_GATEWAY.ROUTENAME = (
	SELECT
		P_ROUTE."ID"
	FROM
		P_ROUTE
	WHERE
		P_GATEWAY.ROUTENAME=P_ROUTE.NUM
) ;