我建了几个表,其中有两个表
clerk_department_position

department_position_privilege

现在我想通过 cherkid 查询到 department 和 position
然后通过 department 和 position 查到 department_position_privilege 表的 privilege

这样分开查是可以查到结果的,然后我就把他整起来了

然后执行,发现他报错
报错信息
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6
有没有大佬能帮忙解决一下
clerk_department_position

department_position_privilege

现在我想通过 cherkid 查询到 department 和 position
然后通过 department 和 position 查到 department_position_privilege 表的 privilege

这样分开查是可以查到结果的,然后我就把他整起来了

然后执行,发现他报错
报错信息
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6
有没有大佬能帮忙解决一下
