Union all的用法实例sql

最新推荐文章于 2025-03-17 17:37:38 发布

weixin_30416871

最新推荐文章于 2025-03-17 17:37:38 发布

阅读量117

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/zxtceq/p/5703704.html

本文提供了一个使用 SQL 的 Unionall 操作符的实际案例。通过一个具体的 SQL 查询语句，展示了如何从不同的数据表中获取数据，并将这些数据合并到一起进行统一处理的方法。

---Union all的用法实例sql
SELECT TOP (100) PERCENT ID, bid_user_id, UserName, amount, createtime, borrowType
FROM (SELECT bid.ID, bid.bid_user_id, reg.UserName, bid.amount, bid.createtime, '普通标' AS borrowType
FROM dbo.YYD_Borrow_BidRecord AS bid
INNER JOIN dbo.YYD_Users_RegInfo AS reg ON reg.ID = bid.bid_user_id
WHERE (bid.ID NOT IN(SELECT bid
FROM dbo.HUR_NewPlanLoan_ItemLoan)) AND (bid.ID NOT IN
(SELECT bidID FROM dbo.HUR_Product_Matching))

UNION ALL

SELECT bid.id, bid.userid, reg.UserName, bid.amount, bid.createtime, '计划' AS borrowType
FROM dbo.HUR_NewPlanLoan_BidRecord AS bid
INNER JOIN dbo.YYD_Users_RegInfo AS reg ON reg.ID = bid.userid

UNION ALL

SELECT buy.buyID, buy.userID, reg.UserName, buy.amount, buy.createDate, '随心买' AS borrowType
FROM dbo.HUR_Product_Buy AS buy
INNER JOIN dbo.YYD_Users_RegInfo AS reg ON reg.ID = buy.userID) AS data
ORDER BY bid_user_id, createtime DESC