Does MS SQL allow to use multiple queries for different columns in INSERT statement?

Question

Is it possible to insert values using multiple queries for different columns? MS SQL allows to write,

INSERT INTO TABLE1(COL1) 
SELECT COL1 FROM TABLE2

But what if I want to insert one data from one table, and another data from another table? Does MS SQL allow it? If so, what is the syntax?

Welcome to Stack Overflow. Please share sample data and your existing code. — Patrick Tucci, Jun 21 '19 at 12:14
You can collect data from different table using JOINING as per requirement. As long as INPUT column number and data type is synced with your selection, there is no issue joining different tables. — mkRabbani, Jun 21 '19 at 12:44

score 0 · Answer 1 · answered Jun 21 '19 at 12:11

0

You can write any select query like :

INSERT INTO TABLE1 (COLUMN1, COLUMN2) SELECT TABLE2.VAL1, TABLE3.VAL2 FROM TABLE2 INNER JOIN TABLE3 ON TABLE2.ID = TABLE3.FID

answered Jun 21 '19 at 12:11

Ibrahim ULUDAG

If the tables aren't related, nothing will get inserted. – SS_DBA Jun 21 '19 at 12:23

1 Answers1