Possible to INSERT INTO a table with values from another table?

Question

So say I want to...

insert into tableA, 2 variables from tableB, but only rows that are in tableB that have 1 of the variables equal to a certain thing...

hmm let's see if I can be more specific...

i want to create a new row in tableA with the userid and courseid from tableB for every row of tableB that has a courseid of 11

please advise

Answer 1

INSERT
INTO    tableA (col1, col2)
SELECT  userid, courseid
FROM    tableB
WHERE   courseid = 11

Answer 2

Well not knowing what columns you have in tableA, I'd say:

insert into tableA
select 
    userid,
    courseid 
from tableB where 
courseid=11

Answer 3

INSERT INTO TableA (userid, courseid)

SELECT userid, courseid FROM TableB
WHERE courseid = 11

That should do it for you.

Answer 4

You didn't mention which database you're using.

MS Access, for me, has proven to be very buggy when trying to do something like this.

Answer 5

You may use SELECT INTO if you are creating a new table using existing data:

SELECT <columns here> INTO tableA FROM tableB WHERE <restrictions here>

If you want to insert existing data into an existing table, you must use:

INSERT INTO tableA (<destination columns>) SELECT <source columns> FROM tableB WHERE <restrictions here>

As described in other answers

Answer 6

insert into tableA(column1,column2,column3) select column1,column2,column3 from table B