这两个表链接查询语句如何写
日期：2014-05-16 浏览次数：20463 次
这两个表链接查询语句怎么写啊
建表脚本
我想得到如下结果，一条sql语句怎么写啊？？ 谢谢
------解决方案--------------------
------解决方案--------------------
建表脚本
/****** Object: Table [dbo].[Table1] Script Date: 03/03/2014 15:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table1](
[id] [int] NOT NULL,
[useridA] [int] NULL,
[useridB] [int] NULL,
[Remark] [nvarchar](50) NULL,
CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
GO
/****** Object: Table [dbo].[Table2] Script Date: 03/03/2014 15:51:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table2](
[id] [int] NOT NULL,
[userName] [nvarchar](50) NULL,
CONSTRAINT [PK_Table2] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
--插入数据
INSERT [Table1] ( [id] , [useridA] , [useridB] , [Remark] ) VALUES ( 1 , 1 , 2 , '3434' )
INSERT [Table1] ( [id] , [useridA] , [useridB] , [Remark] ) VALUES ( 2 , 2 , 3 , 'rewr' )
INSERT [Table1] ( [id] , [useridA] , [useridB] , [Remark] ) VALUES ( 3 , 1 , 1 , 'efsfsfds' )
INSERT [Table1] ( [id] , [useridA] , [useridB] , [Remark] ) VALUES ( 4 , 2 , 1 , '5454' )
INSERT [Table2] ( [id] , [userName] ) VALUES ( 1 , '张一' )
INSERT [Table2] ( [id] , [userName] ) VALUES ( 2 , '张二' )
INSERT [Table2] ( [id] , [userName] ) VALUES ( 3 , '张三' )
INSERT [Table2] ( [id] , [userName] ) VALUES ( 4 , '张四' )
我想得到如下结果，一条sql语句怎么写啊？？ 谢谢
------解决方案--------------------
SELECT a.id,b.userName,c.userName,a.Remark FROM table1 AS a INNER JOIN table2 AS b ON a.useridA=b.id INNER JOIN table2 AS c ON a.useridB=c.id
------解决方案--------------------
SELECT
a.id, b.userName, c.userName, a.Remark
FROM
table1 AS a
INNER JOIN table2 AS b
ON a.useridA=b.id
INNER JOIN table2 AS c
ON a.useridB=c
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
