select [Creator Name]=b.name,[Creator Dept]=b.DeptID
,[Owner Name]=c.name,[Owner Dept]=c.DeptID
from Documents a
join Employees b on a.CreatorID=b.EmployeeID
join Employees c on a.OwnerID=b.EmployeeID
,[Owner Name]=c.name,[Owner Dept]=c.DeptID
from Documents a
join Employees b on a.CreatorID=b.EmployeeID
join Employees c on a.OwnerID=b.EmployeeID
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货