Subquery at Insert

Stephensaw · #1 (**permalink**) 10-31-06, 01:02

I'm going to insert new record to table 1, while one of the value I would like to do some select from other table to get the value, here is what my statement looks like:

Code:

Insert Into Table1(col1,col2,col3)values('1','a',x);

Where the value x I would like to do Select which looks like this:

Code:

Select col6 From Table2 Where col1='abc';

How do I join these two query so that it become one single subquery? THanks.

r937 · #2 (**permalink**) 10-31-06, 07:19

Code:

insert
  into Table1
     ( col1
     , col2
     , col3 )
select '1'
     , 'a'
     , col6
  from Table2
 where col1 = 'abc'

Stephensaw · #3 (**permalink**) 11-01-06, 01:54

Sorry if I'm not stated clearly, the value '1' and value 'a' at the Insert statement I would like to define the value myself, whereby the value x is a value that I get from Select statement, where I select only one column from Table2 where the column1's value at Table2 will be 'abc'...

shammat · #4 (**permalink**) 11-01-06, 02:29

This is exactly what r937's statement does. You will need to replace '1' and 'a' with the value that you "define yourself" obviously.

Internet Services

Web Development

Digital Marketing

Consumer Tech