读书人

请教这个多级查询的niner语句如何就错

发布时间: 2012-02-19 19:43:38 作者: rapoo

请问这个多级查询的niner语句怎么就错了呢?
sql:

select a.strWorkerCode as 员工编号,a.strWorkerName as 员工名称,b.strDepartmentName as 部门编号,
c.strBanZuName as 员工班组名 from tabWorker a INNER JOIN tabDepartment b on a.idDepartmentCode = b.idDepartmentCode,INNER JOIN tabBanZu c on a.strBanZuCode = c.strBanZuCode


提示错误:

在关键字 'INNER ' 附近有语法错误。


[解决办法]
select a.strWorkerCode as 员工编号,a.strWorkerName as 员工名称,b.strDepartmentName as 部门编号,
c.strBanZuName as 员工班组名 from tabWorker a INNER JOIN tabDepartment b on a.idDepartmentCode = b.idDepartmentCode INNER JOIN tabBanZu c on a.strBanZuCode = c.strBanZuCode

多了,号
[解决办法]
select a.strWorkerCode as 员工编号,a.strWorkerName as 员工名称,b.strDepartmentName as 部门编号,
c.strBanZuName as 员工班组名 from tabWorker a
INNER JOIN tabDepartment b on a.idDepartmentCode = b.idDepartmentCode
INNER JOIN tabBanZu c on a.strBaiZuCode = c.strBanZuCode

读书人网 >SQL Server

热点推荐