You can use below table script and can insert any test value for test
cREATE TABLE TAB1
(
URN bigint,
eno varchar(MAX),
Schoolname varchar(MAX),
phase varchar(MAX),
)
cREATE TABLE TAB2
(
URN bigint,
eno varchar(MAX),
Schoolname varchar(MAX),
Region varchar(MAX)
)
cREATE TABLE TABTARGET
(
URN bigint,
eno varchar(MAX),
Schoolname varchar(MAX),
dphase varchar(MAX),
Region varchar(MAX)
)
What is the goal here? Load all of TAB1 into TABTARGET, then load all of TAB2 so you have nulls is some rows for phase and region? Join TAB1 & TAB2 then insert the product into TABTARGET? If the latter what is the relationship between TAB1 & TAB2