摘要：
SELECT 网站名称, 姓名 ,SUM(产品数)as 产品数from(SELECT f.Url as 网站名称, e.Name AS 姓名,a.OrderNumber ,SUM(b.Quality)as 产品数FROM tb_order(nolock) as aleft join tb_OrderList as b on b.OrderID=a.IDleft join tb_WebSitePromotion as c on c.WebSiteInfoID=a.WebSiteInfoID and c.SpreadTypeID=2 and c.StartDate0 and len(isnull( 阅读全文
