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操作を行います.