mysql 多表 UNION ALL用法

最新推荐文章于 2024-04-24 14:00:00 发布

liuxin_0725

最新推荐文章于 2024-04-24 14:00:00 发布

阅读量1.3k

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/liuxin_0725/article/details/79543355

版权

数据库专栏收录该内容

34 篇文章 0 订阅

订阅专栏

SELECT
a.*, c.username
FROM
(
SELECT
userid,
yseid AS id,
\'30\' AS tradeType,
score,
exchangeRatio,
amt AS allFee,
\' \' AS last_score,
createTime AS ddCreatetime,
createTime,
LEFT (createTime, 10) AS ddCreatedate,
status_explain AS `explain`,
`status` AS ddStatus,
(
SELECT
yt01id
FROM
yi_trade01
WHERE
srcid = id
) AS yt01id
FROM
yi_score_exchange
UNION ALL
SELECT
userid,
yscid AS id,
tradeType,
score,
\' \' AS exchangeRatio,
\' \' AS allFee,
last_score,
createTime AS ddCreatetime,
createTime,
LEFT (createTime, 10) AS ddCreatedate,
`explain`,
`status` AS ddStatus,
\' \' AS yt01id
FROM
yi_score_change
) AS a
LEFT JOIN yi_score_change b ON a.id = b.yscid AND a.userid != b.userid
LEFT JOIN sys_login_user c ON b.userid = c.userid AND a.userid != b.userid
WHERE
a.userid = '.$userid;