10表数据集

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