谢谢 最终结果是 select a.ModuleId,ModuleName from ModuleInfo AS A JOIN Purview AS B ON A.ModuleId = B.ModuleId WHERE b.UserID <> 2 and a.parentid <>0
select ModuleId,ModuleName from ModuleInfo AS A INNER JOIN Purview AS B ON A.ModuleId = B.ModuleId WHERE A.UserID <> 2 AND A.Parentid = 0
select ModuleId,ModuleName from ModuleInfo AS A INNER JOIN Purview AS B ON A.ModuleId = B.ModuleId where not (UserId = 2 and ParentId = 0) and Parentid = 0
select a.ModuleId,ModuleName from ModuleInfo AS A
JOIN Purview AS B
ON A.ModuleId = B.ModuleId
WHERE b.UserID <> 2 and a.parentid <>0
INNER JOIN Purview AS B
ON A.ModuleId = B.ModuleId
WHERE A.UserID <> 2 AND A.Parentid = 0
INNER JOIN Purview AS B
ON A.ModuleId = B.ModuleId
where not (UserId = 2 and ParentId = 0)
and Parentid = 0