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

服务器: 消息 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
				
           
         
       
     
   

具体请点击：http://www.verydemo.com/demo_c92_i72145.html