表格1
kgtech ( k_num primary key int , k_name varchar(10))
表格2
kgtest ( t_num int primary key,k_num int foreign key references kgtech(k_num))
要实现
t_num = 1 对应的 k_name 的结果跟 t_num = 2 对应的 k_name 的结果组个一个视图
该如何连接
恳请帮帮忙,感激不尽了
kgtech ( k_num primary key int , k_name varchar(10))
表格2
kgtest ( t_num int primary key,k_num int foreign key references kgtech(k_num))
要实现
t_num = 1 对应的 k_name 的结果跟 t_num = 2 对应的 k_name 的结果组个一个视图
该如何连接
恳请帮帮忙,感激不尽了
Create View V_Info
as
select k_name from kgtech A inner join kgtest B
on A.k_num=B.k_num and B.t_num=1
union all
select k_name from kgtech A inner join kgtest B
on A.k_num=B.k_num and B.t_num=2
但我的想法是想把 t_num = 1 对应的 k_name 的结果作为一列
t_num = 2 对应的 k_name的结果作为一列
即是视图是有两个列的。
select k_num
,k_name as k_nameOne
,k_name as k_nameTwo
into #kgtech
from kgtechupdate A
set A.k_nameOne=k_name
from #kgtech A
join kgtest B
on A.k_num=B.t_num
where B.t_num=1update A
set A.k_nameTwo=k_name
from #kgtech A
join kgtest B
on A.k_num=B.t_num
where B.t_num=2select * from #kgtech