Sql 2005: Insert into - Combining table with static data

Is there a way to insert data from a table with static data..

Have table 1;
ID    value1       value2   comment   team  
have table 2:
ID  value1         value 2
1      2                  3
2      3                  4  
*************************************************
Would like to be able to put data from table 2 into table 1 plus enter for comment and team values like
comment = commenthere and team = teamhere..kinda thing...
TechMonsterAsked:
Who is Participating?
 
LimbeckCommented:
make that

INSERT INTO Tabel1
SELECT ID,value1,value2,"commenthere","teamhere"
FROM Tabel2;
0
 
LimbeckCommented:
hi, you mean like this or should every row have diff. comments?

INSERT INTO Tabel1
SELECT ID,value1,value2,"commenthere","teamhere"
FROM Tabel1;
0
 
TechMonsterAuthor Commented:
Awesome...thank you very much!!!
0
 
LimbeckCommented:
your welcome :) glad to be of help.

Ed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.