2つのsqlクエリunionを使用した後のソートの失効の解決方法

773 ワード

(
	SELECT
		*
	FROM
		(
			SELECT
				a.id,
				a.userId,
				a.infoId,
				a.isRead,
				a.infoType,
				b.title,
				b.createTime
			FROM
				c_user_info a
			LEFT JOIN c_info b ON a.infoId = b.id
			WHERE
				1 = 1
			AND isRead = '0'
			AND userId = '1'
			ORDER BY
				b.createTime DESC
		) AS activity1
)
UNION 
	(
		SELECT
			*
		FROM
			(
				SELECT
					a.id,
					a.userId,
					a.infoId,
					a.isRead,
					a.infoType,
					b.title,
					b.createTime
				FROM
					c_user_info a
				LEFT JOIN c_info b ON a.infoId = b.id
				WHERE
					1 = 1
				AND isRead = '1'
				AND userId = '1'
				ORDER BY
					b.createTime DESC
			) AS activity2
	);
解決方法:sql文ごとにselectを使用 * from(sql文)as activity  ,操作 union操作を行います.