CREATE TABLE [Table 1] ( [File Name] varchar(50), [Effective Date] varchar(50), [File Version ID] varchar(50), [Table Name] varchar(50) )
INSERT INTO [Table 1]
VALUES
( 'File 1', '2021-10-05', '101', 'File1_table' ), 
( 'File 2', '2021-10-05', '102', 'File2_table' )


CREATE TABLE [Table 2] ( [Schema_Name] varchar(50), [Table Name] varchar(50) )
INSERT INTO [Table 2]
VALUES
( 'sch1', 'File1_table' ), 
( 'sch2', 'File2_table' )

CREATE TABLE sch1.File1_table ( [File_Version_ID] varchar(50), [Name] varchar(50), [Qty] varchar(50) )
INSERT INTO sch1.File1_table
VALUES
( '101', 'aaa', '10' ), 
( '101', 'bbb', '20' ), 
( '101', 'ccc', '30' )

CREATE TABLE sch2.File2_table ( [File_Version_ID] varchar(50), [Name] varchar(50), [Qty] varchar(50) )
INSERT INTO sch2.File2_table 
VALUES
( '102', 'ccc1', '300' ), 
( '102', 'DDD1', '500' ), 
( '102', 'FFFDDD1', 'FF500' )