34,590
社区成员
发帖
与我相关
我的任务
分享
with tbProject(ProjectName) as
(
select '国电集团'
union all select'中信银行'
union all select'中国联通'
union all select'中国移动'
union all select'外运长航'
union all select'中航重工'
union all select'一汽集团'
union all select'昌河集团'
),
tbUnit (UnitName) as
(
select '中国移动'
union all select'中国网通'
union all select'中国铁通'
union all select'一汽集团'
union all select'华夏银行'
union all select'中国黄金'
)
select * from tbProject
left join tbUnit on tbProject.ProjectName=tbUnit.UnitName
union
select * from tbProject
right join tbUnit on tbProject.ProjectName=tbUnit.UnitName
select *
from 项目名称表 a full join 往来单位表 b on a.项目名称=b.往来单位
SELECT T1.项目名称,T2.往来单位
FROM 项目名称表 T1
FULL JOIN 往来单位表 T2 ON T1.项目名称=T2.往来单位