SQL子查询错误附近）

Question

我的子查询提供了一个错误：Msg 102, Level 15, State 1, Line 17 Incorrect syntax near ')'.

SELECT SalesArea, Branch, Volume 
from 
(select 
br.SalesArea as SalesArea 
,br.Branch as Branch 
, sum(a.Volume) as Volume 
FROM dbo.vDetail a with (nolock) 
LEFT JOIN 
dbo.vBranch AS br WITH (nolock) 
ON a.Branch = br.Branch 
group by a.Volume, br.SalesArea, br.Branch) 

Answer 1

你缺少别名子查询尝试这个。

SELECT SalesArea, Branch, Volume 
from 
(select 
br.SalesArea as SalesArea 
,br.Branch as Branch 
, sum(a.Volume) as Volume 
FROM dbo.vDetail a with (nolock) 
LEFT JOIN 
dbo.vBranch AS br WITH (nolock) 
ON a.Branch = br.Branch 
group by a.Volume, br.SalesArea, br.Branch) as x 

Answer 2

您需要别名为派生表

SELECT SalesArea, Branch, Volume 
from 
(select 
br.SalesArea as SalesArea 
,br.Branch as Branch 
, sum(a.Volume) as Volume 
FROM dbo.vDetail a with (nolock) 
LEFT JOIN 
dbo.vBranch AS br WITH (nolock) 
ON a.Branch = br.Branch 
group by a.Volume, br.SalesArea, br.Branch) as T 

Answer 3

从子查询每一个选择需要的别名。只需添加在最后的 “X”，这将成为该表

NOT OK的名字：

select * from (
    select * from your_table 
) 

OK：

select * from (
    select * from your_table 
) X