请问下有这SQL语句怎写???

qq_28939113 qq_28939113 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
CREATE TABLE [dbo].[T1](
[No] [varchar](50) NULL,
[Item1] [varchar](50) NULL,
[Item2] [varchar](50) NULL
)
CREATE TABLE [dbo].[T2](
[No] [varchar](50) NULL,
[Item5] [varchar](50) NULL,
[Item6] [varchar](50) NULL
)
CREATE TABLE [dbo].[T3](
[No] [varchar](50) NULL,
[Item7] [varchar](50) NULL,
[Item8] [varchar](50) NULL
)

insert into T1 (No,Item1,Item2) values ('A0001','A1','B1')
insert into T1 (No,Item1,Item2) values ('A0001','A2','B2')
insert into T1 (No,Item1,Item2) values ('A0001','A3','B3')
insert into T1 (No,Item1,Item2) values ('A0002','A4','')
insert into T1 (No,Item1,Item2) values ('A0002','A5','')

insert into T2 (No,Item5,Item6) values ('A0001','C1','D1')
insert into T2 (No,Item5,Item6) values ('A0001','C2','D2')
insert into T2 (No,Item5,Item6) values ('A0001','C3','D3')
insert into T2 (No,Item5,Item6) values ('A0001','C4','D4')
insert into T2 (No,Item5,Item6) values ('A0001','C5','D5')
insert into T2 (No,Item5,Item6) values ('A0001','C6','D6')

insert into T3 (No,Item7,Item8) values ('A0001','E1','F1')
insert into T3 (No,Item7,Item8) values ('A0001','E2','F2')
insert into T3 (No,Item7,Item8) values ('A0001','E3','F3')
insert into T3 (No,Item7,Item8) values ('A0001','E4','F4')
insert into T3 (No,Item7,Item8) values ('A0002','E5','F5')
insert into T3 (No,Item7,Item8) values ('A0002','E6','F6')
insert into T3 (No,Item7,Item8) values ('A0002','E6','F6')



实现将表1、表2、表3 数据组合成表4,有高手帮忙下?谢谢
...全文

相关推荐

评论 3
收藏 已收藏
分享
返回顶部
qq_28939113
应用实例 27,579 成员 68,540 内容