SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

DECLARE @T AS TABLE
(
	ROW_ID  int,
	predicateName sysname,
	EntityName sysname
);

INSERT INTO @T (ROW_ID, predicateName, EntityName) VALUES
(1, 'AGE', 'tbl_PR_AGE_VALIDATION_RULE'),
(2, 'SALARY', 'tbl_PR_AGE_VALIDATION_RULE'),
(3, 'GENDER', 'tbl_PR_AGE_VALIDATION_RULE'),
(4, 'DATEOBIRTH', 'tbl_PR_AGE_VALIDATION_RULE'),
(5, 'CITY', 'tbl_PR_AGE_VALIDATION_RULE'),
(6, 'TEST1', 'tbl_PR_PAGE_VALIDATION_RULE'),
(7, 'TEST2', 'tbl_PR_CITY_VALIDATION');

DECLARE @TableName sysname = 'tbl_PR_AGE_VALIDATION_RULE';

DECLARE @Sql nvarchar(max), 
        @Tab nchar = NCHAR(9),
        @LineBreak nchar(2) = NCHAR(13) + NCHAR(10),
        @ColumnSeperaor NCHAR(4);
SET @ColumnSeperaor = ',' + @LineBreak + @Tab ;

SELECT @Sql = 'SELECT '+ STRING_AGG(QUOTENAME(EntityName) + '.'+ QUOTENAME(predicateName), @ColumnSeperaor) + @LineBreak
FROM @T

PRINT @Sql

SELECT @Sql = @Sql + 'FROM '+ QUOTENAME(@TableName) + @LineBreak

PRINT @Sql

SET @Sql = @Sql + 
(
    SELECT DISTINCT 'LEFT JOIN ' + QUOTENAME(EntityName) + @LineBreak + @Tab + 'ON '+ QUOTENAME(@TableName) + '.ENTITY_ID = '+ QUOTENAME(EntityName) +'.ENTITY_ID ' + @LineBreak 
    FROM @T
    WHERE EntityName <> @TableName
    FOR XML PATH(''),TYPE 
).value('.[1]','varchar(max)')

PRINT @Sql

--EXEC @Sql

SELECT [tbl_PR_AGE_VALIDATION_RULE].[AGE],
	[tbl_PR_AGE_VALIDATION_RULE].[SALARY],
	[tbl_PR_AGE_VALIDATION_RULE].[GENDER],
	[tbl_PR_AGE_VALIDATION_RULE].[DATEOBIRTH],
	[tbl_PR_AGE_VALIDATION_RULE].[CITY],
	[tbl_PR_PAGE_VALIDATION_RULE].[TEST1],
	[tbl_PR_CITY_VALIDATION].[TEST2]

SELECT [tbl_PR_AGE_VALIDATION_RULE].[AGE],
	[tbl_PR_AGE_VALIDATION_RULE].[SALARY],
	[tbl_PR_AGE_VALIDATION_RULE].[GENDER],
	[tbl_PR_AGE_VALIDATION_RULE].[DATEOBIRTH],
	[tbl_PR_AGE_VALIDATION_RULE].[CITY],
	[tbl_PR_PAGE_VALIDATION_RULE].[TEST1],
	[tbl_PR_CITY_VALIDATION].[TEST2]
FROM [tbl_PR_AGE_VALIDATION_RULE]

SELECT [tbl_PR_AGE_VALIDATION_RULE].[AGE],
	[tbl_PR_AGE_VALIDATION_RULE].[SALARY],
	[tbl_PR_AGE_VALIDATION_RULE].[GENDER],
	[tbl_PR_AGE_VALIDATION_RULE].[DATEOBIRTH],
	[tbl_PR_AGE_VALIDATION_RULE].[CITY],
	[tbl_PR_PAGE_VALIDATION_RULE].[TEST1],
	[tbl_PR_CITY_VALIDATION].[TEST2]
FROM [tbl_PR_AGE_VALIDATION_RULE]
LEFT JOIN [tbl_PR_CITY_VALIDATION]
	ON [tbl_PR_AGE_VALIDATION_RULE].ENTITY_ID = [tbl_PR_CITY_VALIDATION].ENTITY_ID 
LEFT JOIN [tbl_PR_PAGE_VALIDATION_RULE]
	ON [tbl_PR_AGE_VALIDATION_RULE].ENTITY_ID = [tbl_PR_PAGE_VALIDATION_RULE].ENTITY_ID 

7 rows affected