How to insert values from multiple tables to a single table?

http://www.java2s.com/Tutorial/Oracle/0080__Insert-Update-Delete/Combinethreetableswithinsertintostatement.htm[^]

Check the link. It creates three tables, populate them and then populate the fourth table from them. This would help you learn how you should proceed.

You can use SELECT INTO to do this
Ex:

SELECT Persons.LastName,Orders.OrderNo
INTO Persons_Order_Backup
FROM Persons
INNER JOIN Orders
ON Persons.P_Id=Orders.P_Id

Read more about select into here[^]

Refer this link:

http://www.sqlservercentral.com/Forums/Topic513892-338-1.aspx[^]

u can something as:

INSERT INTO NewTable (SELECT tab1_col1, tab2.col2,tab3.col1 FROM   tab1, tab2,tab3 WHERE  Condtion)

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

Hi, use below query

Insert into table3( Field1 , Field2 , Field3)
select TB1.Field1,TB1.Field2,TB1.Field3
from TB1 inner join TB2
where TB1.prKey = TB2.FrKey