第一问答网»论坛 › 中问网 › 问答 › 谁能帮我把这个SQL查询语句简化一下

谁能帮我把这个SQL查询语句简化一下

11 |

1 | 2011-4-12 06:14:24 | 显示全部楼层 |阅读模式

SELECT Employee.emp_Name, Departments.dep_Name, Post.pos_Name, Users.use_Id, Permissions.P_Name from Users INNER JOINEmployee ON Users.use_Emid = Employee.emp_Id INNER JOIN Departments ON Employee.emp_Depid = Departments.dep_Id INNER JOINPost ON Employee.emp_Posid = Post.pos_Id INNER JOIN Permissions ON Users.use_Perid = Permissions.ID

使用道具举报