SQL Insert multiple Values where 1 value comes from a select query

Question

I am searching for a solution to add multiple values into a table where one of these values is coming from another table. Something like this:

INSERT INTO Table2 (Telnumber, adress) VALUES ('12324567890',
SELECT applicatieID from Applicatie WHERE Naam = 'piet' )

So 1 of the values has to come from another table and the other values I have to insert myself. The above query won't work. Does anybody have a solution?

Gordon Linoff · Accepted Answer · 2014-10-07 12:12:58Z

3

Use insert . . . select:

INSERT INTO Table2 (Telnumber, adress)
    SELECT '12324567890', applicatieID
    from Applicatie
    WHERE Naam = 'piet';

insert . . . select does almost everything that insert . . . values does, plus more.

answered Oct 7, 2014 at 12:12

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Comments

Gilles V. · Accepted Answer · 2014-10-07 12:12:52Z

1

You can use INSERT INTO with your SELECT request :

INSERT INTO Table2 (Telnumber, adress) 
SELECT '1234567890', applicatieID 
FROM Applicatie 
WHERE Naam = 'piet'

answered Oct 7, 2014 at 12:12

Gilles V.

1,40413 silver badges22 bronze badges

Collectives™ on Stack Overflow

SQL Insert multiple Values where 1 value comes from a select query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related