SQL Server 2016

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

CREATE TABLE tblTemp (id INT, b INT, tblName varchar(50));
INSERT INTO tblTemp VALUES (1003, 4, 'GER');
INSERT INTO tblTemp VALUES (1005, 3, 'AUS');
INSERT INTO tblTemp VALUES (1006, 3, 'USA');
INSERT INTO tblTemp VALUES (1008, 3, 'UK');
INSERT INTO tblTemp VALUES (1009, 3, 'POL');

CREATE TABLE tblProj (colOrder INT, Name varchar(50), tblName varchar(50));
INSERT INTO tblProj VALUES (1, 'City','UK');
INSERT INTO tblProj VALUES (2, 'Name','UK');
INSERT INTO tblProj VALUES (3, 'EmpId','UK');
INSERT INTO tblProj VALUES (4, 'Phone','UK');
INSERT INTO tblProj VALUES (5, 'State','UK');

INSERT INTO tblProj VALUES (1, 'City','USA');
INSERT INTO tblProj VALUES (2, 'State','USA');
INSERT INTO tblProj VALUES (3, 'Name','USA');
INSERT INTO tblProj VALUES (4, 'EmpId','USA');

INSERT INTO tblProj VALUES (1, 'City','AUS');
INSERT INTO tblProj VALUES (2, 'Name','AUS');
INSERT INTO tblProj VALUES (3, 'State','AUS');
INSERT INTO tblProj VALUES (4, 'EmpId','AUS');

INSERT INTO tblProj VALUES (1, 'City','POL');
INSERT INTO tblProj VALUES (2, 'Name','POL');
INSERT INTO tblProj VALUES (3, 'Phone','POL');
INSERT INTO tblProj VALUES (4, 'EmpId','POL');

CREATE TABLE tblData (Id INT, col varchar(50), tmpId INT);
INSERT INTO tblData VALUES (1, 'sample1', 1005);
INSERT INTO tblData VALUES (2, 'sample2', 1006);
INSERT INTO tblData VALUES (3, 'sample3', 1009);
INSERT INTO tblData VALUES (4, 'samplef', 1008);
INSERT INTO tblData VALUES (5, 'sample8', 1005);
INSERT INTO tblData VALUES (6, 'samplez', 1006);
INSERT INTO tblData VALUES (7, 'samples', 1006);
INSERT INTO tblData VALUES (8, 'sampdf', 1008);

30 rows affected

Msg 8155 Level 16 State 2 Line 9
No column name was specified for column 1 of 'd'.
Msg 207 Level 16 State 1 Line 2
Invalid column name 'colName'.