نحوه استفاده از دستور Inner Join و SELECT و ارتباط چند جدولی

سلام

CREATE TABLE [dbo].[t1](
	[UserId] [int] IDENTITY(1,1) NOT NULL,
	[UserName] [nvarchar](50) NULL,
 CONSTRAINT [PK_t1] PRIMARY KEY CLUSTERED 
(
	[UserId] 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
CREATE TABLE [dbo].[t2](
	[WorkId] [int] IDENTITY(1,1) NOT NULL,
	[WorkTitle] [nvarchar](50) NULL,
	[ReUserId] [int] NULL,
	[RebUserId] [int] NULL,
 CONSTRAINT [PK_t2] PRIMARY KEY CLUSTERED 
(
	[WorkId] 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
select
[t2].WorkId, [t2].WorkTitle ,
t1_1.UserName as 'ReUserName',
t1_2.UserName as 'bReUserName'
 from [dbo].[t2] 
 inner join [dbo].[t1] as t1_1 on t2.ReUserId=t1_1.UserId 
 inner join [dbo].[t1] as t1_2 on t2.RebUserId=t1_2. UserId