Insert using variables and another table's column

Question

I'm trying to write a "simple" INSERT comand in SQL.

INSERT TABLE_A (COLUMN_1_TABLE_A, COLUMN_2_TABLE_A, COLUMN_3_TABLE_A)
        VALUES (@variable_1, @variable_2, (SELECT * FROM TABLE_B))

Now, TABLE_B has one column and a variable number of rows. How can I loop through all TABLE_B rows using its values for all the inserts?

Yogesh Sharma · Accepted Answer · 2018-12-04 16:13:02Z

4

You can use SELECT statement with INSERT INTO . . :

INSERT TABLE_A (COLUMN_1_TABLE_A, COLUMN_2_TABLE_A, COLUMN_3_TABLE_A)
    SELECT @variable_1, @variable_2, b.COL
    FROM TABLE_B b

answered Dec 4, 2018 at 16:13

Yogesh Sharma

50.2k5 gold badges31 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Perfect. Thanks a lot.