連接就已經構成一個表了，所以這個表可以有條件查詢的

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

where DepartmentName like '%%'