SQL Server 相同数据汇总问题

Question

Adodc1.RecordSource = "select 位置,位置 from (select sum(数量) as 数量,位置 from SMT_DATA group by 位置)"
用MDB 数据库就可以，使用 SQL Server报")"附件原语法错误

以下是代码 还请各位大伽帮忙看看
谢谢

Private Sub Command1_Click()
Adodc1.RecordSource = "select 位置,位置 from (select sum(数量) as 数量,位置 from SMT_DATA group by 位置)" 'MDB 数据库ok SQL Server报")"附件原语法错误
Adodc1.Refresh
Set MSChart1.DataSource = Adodc1
End Sub

Private Sub Form_Load()
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\db_medicine.mdb;Persist Security Info=False" 'MDB 数据库
Adodc1.ConnectionString = "Provider=SQLOLEDB;server=" & "192.168.0.220" & ";uid=sa;pwd=" & "6600" & ";Initial Catalog=PE" ' SQL Server
End Sub

Answer 1

改为：select t1.位置,t1.位置 from (select sum(数量) as 数量,位置 from SMT_DATA group by 位置) t1

亲自试有效，求分！