日期:2014-05-18  浏览次数:20434 次

请问这个多级查询的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