2.mysql 将查询出来的表设置别名用法

需求及代码见下：

</pre><pre name="code" class="sql">INSERT INTO tb_xynrj_detail (
	sdate,
	corpid,
	appid,
	js_user,
	yx_user,
	repeatimei_user,
	noimsi_user,
	xz_user
) SELECT
	sdate,
	corpid,
	appid,
	js_user,
	yx_user,
	repeatimei_user,
	noimsi_user,
	(
		yx_user + repeatimei_user + noimsi_user
	) AS xz_user
FROM
	(
		SELECT
			sdate,
			corpid,
			appid,
			ROUND((RAND()*0.4+0.8)*(js_user)) AS js_user,
			ROUND((RAND()*0.4+0.8)*(js_user * yx_ratio)) AS yx_user,
			ROUND((RAND()*0.4+0.8)*(js_user * repeatimei_ratio)) AS repeatimei_user,
			ROUND((RAND()*0.4+0.8)*(js_user * noimsi_ratio)) AS noimsi_user
		FROM
			(
				SELECT
					rep.sdate AS sdate,
					app.channelid AS corpid,
					rep.appid as appid,
					(
						rep.hcount + rep.mcount + rep.lcount
					) AS js_user,
					app.yx_ratio AS yx_ratio,
					app.noimsi_ratio AS noimsi_ratio,
					app.repeatimei_ratio AS repeatimei_ratio
				FROM
					tbn_appreport AS rep
				INNER JOIN tb_customerapp AS app ON rep.appid = app.id
				WHERE
					sdate = '20151202'
			) AS vj
	) vj2