脚本中多表查询

SELECT u.id AS id FROM obpm.t_user u,obpm.T_department d,obpm.T_USER_DEPARTMENT_SET s,obpm.t_role r,obpm.T_USER_ROLE_SET t WHERE u.id=s.userid AND d.id=s.DEPARTMENTID
AND u.id=t.USERID AND r.id=t.ROLEID AND r.NAME="部门经理" AND s.DEPARTMENTID IN
(SELECT obpm.T_department.id FROM obpm.T_department,obpm.t_user,obpm.T_USER_DEPARTMENT_SET WHERE obpm.t_user.id=obpm.T_USER_DEPARTMENT_SET.userid AND obpm.T_department.id=obpm.T_USER_DEPARTMENT_SET.DEPARTMENTID
AND obpm.t_user.name="test01")
麻烦同道中人帮我在脚本调试下，该代码在mysql已经执行通过了。非常感谢！！！
我用了一下午时间，始终提示语法错误。

(⊙o⊙)…，脚本里面不是您这样写的哦，您试下下面这段代码。
var sql = "SELECT u.id AS id,u.domainid FROM obpm.t_user u,obpm.T_department d,obpm.T_USER_DEPARTMENT_SET s,obpm.t_role r,obpm.T_USER_ROLE_SET t"
+" WHERE u.id=s.userid AND d.id=s.DEPARTMENTID AND u.id=t.USERID AND r.id=t.ROLEID AND r.NAME='部门经理' AND s.DEPARTMENTID"
+" IN (SELECT obpm.T_department.id FROM obpm.T_department,obpm.t_user,obpm.T_USER_DEPARTMENT_SET "
+" WHERE obpm.t_user.id=obpm.T_USER_DEPARTMENT_SET.userid AND obpm.T_department.id=obpm.T_USER_DEPARTMENT_SET.DEPARTMENTID
+" AND obpm.t_user.name='test01'";