表联合查询 表合并

[jievip1990]

SELECT a.VenderID,a.name,SUM(salevalue-discvalue) truesale, SUM(salevalue-discvalue-CostValue) maoli FROM dbo.Vender a, SaleCost201511 b WHERE a.VenderID=b.VenderID
GROUP BY a.VenderID,a.Name

SELECT a.venderid,a.NAME , SUM(closecostv) closecostv FROM dbo.Vender a,dbo.WasteBook201511 c WHERE a.VenderID=c.VenderID
GROUP BY a.VenderID,a.Name

要怎么把这两张表结合起来结果大致为
venderid name truesale moli closecostv
XXX XXX XXX XX XXXX

相同的就显示一个结果，没有的也要显示出来。查询结果合并起来

[中国风]

SELECT  a.VenderID
       ,a.name
       ,b.truesale
       ,b.maoli
       ,c.closecostv
FROM    dbo.Vender a
       LEFT JOIN (SELECT VenderID,SUM(salevalue - discvalue) truesale,SUM(salevalue - discvalue - CostValue) maoli FROM SaleCost201511 GROUP BY venderid) b ON a.VenderID = b.VenderID
       LEFT JOIN (SELECT VenderID,SUM(closecostv) closecostv FROM dbo.WasteBook201511 GROUP BY venderid) ON a.VenderID = c.VenderID
WHERE   b.VenderID IS NOT NULL OR c.VenderID IS NOT NULL