If yor are directly inserting data i mean if you are passing values as a parameter then you can write direct query like
INSERT INTO table3(Code) Values ('aaa');
INSERT INTO MessageStatus (Code) Values ('Status01');
Or you can do following
1)If your new column is static then
declare @newColID int, @PQID int
Set @newColID = 1
set @PQID =1234
Insert into table3( [PQID] , [col1] , [col2], [newColID])
select PQID,col1,col2, @newColID
from TB1 where TB1.[PQID] = @PQID
2)If your new column resides in another table(TB2)
If your new column is in a different table (related to TB1 through PQID)
Insert into table3( [PQID] , [col1] , [col2], [newColID])
select TB1.PQID,TB1.col1,TB1.col2, TB2.newColID
from TB1 INNER JOIN TB2 ON TB1.PQID = TB2.PQID
where TB1.[PQID] = @PQID
Or
Insert into table3( [PQID] , [col1] , [col2], [newColID])
select TB1.PQID,TB1.col1,TB1.col2, TB2.newColID
from TB1 , TB2
where TB1.[PQID] = @PQID
and TB1.PQID = TB2.PQID
Please let me know if it helps you.
Thanks
Prashant