Table1

Create table T1

C1 varchar(50)

Insert into T1 Values ('TCR-12345ABCDEF')

GO

Insert into T1 Values('TCR-13245HIJKLM')

GO

Insert into T1 Values('TCR-14567RSTUV')

Table2

Create Table T2

(C1 varchar (50),

C2 varchat (50),

C3 varchar(50),

C4 varchar(50)

)

insert into T2 values('12345','ABCDEF','98765','PQRST')

GO

insert...