22,207
社区成员
发帖
与我相关
我的任务
分享
-- 这个要关联两次 DepartmentInfo 表
create view v1
as
select p.Name ,
d1.Name DepartmenIn, d1.Address AddrIn,
d2.Name DepartmenOut, d2.Address AddrOut
from Product p
inner join DepartmentInfo d1 on p.DepartmenIn = d1.Id
inner join DepartmentInfo d2 on p.DepartmentOut = d2.Id