服务器: 消息 170，级别 15，状态 1，行 14

SELECT c.ThreeCantonNumber as areano,c.ThreeCantonName,(a.FirstCantonName+b.SecondCantonName+c.ThreeCantonName) as AreaName from(
SELECT a.FirstCantonNumber, 
  b.SecondCantonNumber, 
  c.ThreeCantonNumber, a.FirstCantonName, 
  b.SecondCantonName, 
  c.ThreeCantonName
FROM dbo.T_FirstCanton a LEFT OUTER JOIN
  dbo.T_SecondCanton b ON 
  a.FirstCantonNumber = b.FirstCantonNumber LEFT
  OUTER JOIN
  dbo.T_ThreeCanton c ON 
  b.SecondCantonNumber = c.SecondCantonNumber
)
服务器: 消息 170，级别 15，状态 1，行 14
第 14 行: ')' 附近有语法错误。

SQL code

SELECT c.ThreeCantonNumber as areano,c.ThreeCantonName,(a.FirstCantonName+b.SecondCantonName+c.ThreeCantonName) as AreaName from(
SELECT a.FirstCantonNumber,  
  b.SecondCantonNumber,  
  c.ThreeCantonNumber, a.FirstCantonName,  
  b.SecondCantonName,  
  c.ThreeCantonName
FROM dbo.T_FirstCanton a LEFT OUTER JOIN
  dbo.T_SecondCanton b ON  
  a.FirstCantonNumber = b.FirstCantonNumber LEFT
  OUTER JOIN
  dbo.T_ThreeCanton c ON  
  b.SecondCantonNumber = c.SecondCantonNumber
) t--加个别名

SQL code

SELECT c.ThreeCantonNumber as areano,c.ThreeCantonName,(a.FirstCantonName+b.SecondCantonName+c.ThreeCantonName) as AreaName from(
SELECT a.FirstCantonNumber,  
  b.SecondCantonNumber,  
  c.ThreeCantonNumber, a.FirstCantonName,  
  b.SecondCantonName,  
  c.ThreeCantonName
FROM dbo.T_FirstCanton a LEFT OUTER JOIN
  dbo.T_SecondCanton b ON  
  a.FirstCantonNumber = b.FirstCantonNumber LEFT
  OUTER JOIN
  dbo.T_ThreeCanton c ON  
  b.SecondCantonNumber = c.SecondCantonNumber
) as a --别名

SQL code

SELECT ThreeCantonNumber as areano,ThreeCantonName,(FirstCantonName+SecondCantonName+ThreeCantonName) as AreaName from
(
SELECT a.FirstCantonNumber,  
  b.SecondCantonNumber,  
  c.ThreeCantonNumber, a.FirstCantonName,  
  b.SecondCantonName,  
  c.ThreeCantonName
FROM dbo.T_FirstCanton a LEFT OUTER JOIN
  dbo.T_SecondCanton b ON  
  a.FirstCantonNumber = b.FirstCantonNumber LEFT
  OUTER JOIN
  dbo.T_ThreeCanton c ON  
  b.SecondCantonNumber = c.SecondCantonNumber
) AS T

SQL code

SELECT c.ThreeCantonNumber as areano,c.ThreeCantonName,(a.FirstCantonName+b.SecondCantonName+c.ThreeCantonName) as AreaName from(
SELECT a.FirstCantonNumber,  
  b.SecondCantonNumber,  
  c.ThreeCantonNumber, a.FirstCantonName,  
  b.SecondCantonName,  
  c.ThreeCantonName
FROM dbo.T_FirstCanton a LEFT OUTER JOIN
  dbo.T_SecondCanton b ON  
  a.FirstCantonNumber = b.FirstCantonNumber LEFT
  OUTER JOIN
  dbo.T_ThreeCanton c ON  
  b.SecondCantonNumber = c.SecondCantonNumber
)tt

直接

SQL code

SELECT c.ThreeCantonNumber as areano,c.ThreeCantonName,(a.FirstCantonName+b.SecondCantonName+c.ThreeCantonName) as AreaName 
FROM dbo.T_FirstCanton a LEFT OUTER JOIN
  dbo.T_SecondCanton b ON  
  a.FirstCantonNumber = b.FirstCantonNumber LEFT
  OUTER JOIN
  dbo.T_ThreeCanton c ON  
  b.SecondCantonNumber = c.SecondCantonNumber

子查询必须别名

SQL code

SELECT ThreeCantonNumber as areano,ThreeCantonName,(FirstCantonNameA+SecondCantonNameB+ThreeCantonNameC) as AreaName from
(
SELECT a.FirstCantonNumber,  
  b.SecondCantonNumber,  
  c.ThreeCantonNumber, a.FirstCantonName AS FirstCantonNameA , 
  b.SecondCantonName AS FirstCantonNameB  ,  
  c.ThreeCantonName AS FirstCantonNameC  
FROM dbo.T_FirstCanton a LEFT OUTER JOIN
  dbo.T_SecondCanton b ON  
  a.FirstCantonNumber = b.FirstCantonNumber LEFT
  OUTER JOIN
  dbo.T_ThreeCanton c ON  
  b.SecondCantonNumber = c.SecondCantonNumber
) AS T