@prolifes 是对的。也许题主没表述清楚。
我补充另外一个思路,因为你最后只需要5条数据,从ca中取5条,再从aa中取5条,总共10条排序,这个会很快。
SELECT
a. KEY,
a. DATA,
a.date_added
FROM
(
(
SELECT
CONCAT('customer_', ca. KEY) AS `key`,
ca. DATA,
ca.date_added
FROM
`cf_customer_activity` ca
ORDER BY
a.date_added DESC /* 如果date_added有索引的话,这个会比较快 */
LIMIT 0,5
)
UNION ALL
(
SELECT
CONCAT('affiliate_', aa. KEY) AS `key`,
aa. DATA,
aa.date_added
FROM
`cf_affiliate_activity` aa
ORDER BY
a.date_added DESC /* 如果date_added有索引的话,这个会比较快 */
LIMIT 0,5
)
) a
ORDER BY
a.date_added DESC
LIMIT 0, 5;