连接就已经构成一个表了，所以这个表可以有条件查询的

SELECT b.FunctionID, b.Functions, a.DepartmentName, a.DepartmentID FROM dbo.TOrganization_DepartmentBasicInfo as a left JOIN dbo.TOrganization_FunctionInfo as b ON a.FunctionID = b.FunctionID SELECT b.FunctionID, b.Functions, a.DepartmentN