＞ 1248 - Every derived table must have its own alias mysql

1248 - Every derived table must have its own alias 报错
一般是由于union后产生了虚拟表，但没有进行定义
错误sql如下：

SELECT
	* 
FROM
	(
		(
		SELECT
			gaform_lpt_30.file_id file_id,
			gaform_lpt_30.gettime gettime 
		FROM
			`gaform_lpt_30` 
		WHERE
			allagree = 1 
		) UNION ALL
		(
		SELECT
			gaform_lpt_29.file_id file_id,
			gaform_lpt_29.gettime gettime 
		FROM
			`gaform_lpt_29` 
		WHERE
			allagree = 1 
		) 
	) 
ORDER BY
	t.gettime DESC

修改后的代码

SELECT
	* 
FROM
	(
		(
		SELECT
			gaform_lpt_30.file_id file_id,
			gaform_lpt_30.gettime gettime 
		FROM
			`gaform_lpt_30` 
		WHERE
			allagree = 1 
		) UNION ALL
		(
		SELECT
			gaform_lpt_29.file_id file_id,
			gaform_lpt_29.gettime gettime 
		FROM
			`gaform_lpt_29` 
		WHERE
			allagree = 1 
		) 
	) AS t 
ORDER BY
	t.gettime  DESC