10表数据集

最新推荐文章于 2025-05-14 09:12:33 发布

sdt0263

最新推荐文章于 2025-05-14 09:12:33 发布

阅读量671

点赞数

CC 4.0 BY-SA版权

文章标签： email

本文链接：https://blog.youkuaiyun.com/sdt0263/article/details/6230267

本文介绍了一种复杂的SQL查询方法，通过联合使用多个表的数据并获取特定站点的最新订单详情。涉及从不同的订单表如GoldOrder、PLOrder等中提取前10条记录，并展示这些记录的电子邮件、代码及产品名称等信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

select * from
(
select top 10 email,code,sitecode,
(select top 1 [name] from dbo.GoldOrderProduct
where ordercode = GoldOrder.code) as [name]
from dbo.GoldOrder where sitecode='b' order by createtime desc
) as t
union all
select * from
(
select top 10 email,code,
(select top 1 [name] from dbo.PLOrderProduct
where ordercode = PLOrder.code) as [name]
from dbo.PLOrder where sitecode='b' order by createtime desc
) as t1
union all
select * from
(
select top 10 email,code,
(select top 1 [name] from dbo.CDKOrderProduct
where ordercode = CDKOrder.code) as [name]
from dbo.CDKOrder where sitecode='b' order by createtime desc
) as t1
union all
select * from
(
select top 10 email,code,
(select top 1 [name] from dbo.StaffOrderProduct
where ordercode = StaffOrder.code) as [name]
from dbo.StaffOrder where sitecode='b' order by createtime desc
) as t1
union all
select * from
(
select top 10 email,code,
(select top 1 [name] from dbo.ItemOrderProduct
where ordercode = ItemOrder.code) as [name]
from dbo.ItemOrder where sitecode='b' order by createtime desc
) as t1