CREATE TABLE [dbo].[Table_2](
	[c1] [int] NULL,
	[c2] [nvarchar](50) NULL
) ON [PRIMARY]
GO
INSERT [dbo].[Table_2] ([c1], [c2]) VALUES (1, N'z')
INSERT [dbo].[Table_2] ([c1], [c2]) VALUES (2, N'y')
INSERT [dbo].[Table_2] ([c1], [c2]) VALUES (3, N'x')
INSERT [dbo].[Table_2] ([c1], [c2]) VALUES (4, N'a')
INSERT [dbo].[Table_2] ([c1], [c2]) VALUES (5, N'b')
INSERT [dbo].[Table_2] ([c1], [c2]) VALUES (6, N'c')

CREATE TABLE [dbo].[Table_1](
	[c1] [int] NULL,
	[c2] [nvarchar](50) NULL
) ON [PRIMARY]
GO
INSERT [dbo].[Table_1] ([c1], [c2]) VALUES (3, N'x')
INSERT [dbo].[Table_1] ([c1], [c2]) VALUES (2, N'y')
INSERT [dbo].[Table_1] ([c1], [c2]) VALUES (1, N'z')
INSERT [dbo].[Table_1] ([c1], [c2]) VALUES (6, N'c')
INSERT [dbo].[Table_1] ([c1], [c2]) VALUES (5, N'b')
INSERT [dbo].[Table_1] ([c1], [c2]) VALUES (4, N'a')

----------------------------------------------------

IF OBJECT_ID('TempDB..#tblTemp','U') IS NOT NULL
	DROP TABLE #tblTemp
        
CREATE TABLE #tblTemp (Id int);

INSERT INTO #tblTemp SELECT c1 FROM Table_2 ORDER BY c2

SELECT * 
FROM Table_1
	INNER JOIN #tblTemp ON Id=Table_1.c1
	
DROP TABLE #tblTemp

We walk in the dark places no others will enter
We stand on the bridge and no one may pass