Inserting foreign key value

• forum member

  Ten Centuries

  Points: 1290

  More actions

  January 31, 2010 at 9:43 pm

  #138652

  Hi There,

  Please suggest best way to do this

  insert into table(value1,value2)

  values ('123', select id from table where section='section 1')

  value2 is the foreign key value from the second table

  but this doesnt work,i have to declare a variable and set the above select value into the variable

  and replace this above select statement with the variable

  Please suggest best way to achieve this

  Thanks

• vstitte

  SSCarpal Tunnel

  Points: 4475

  More actions

  January 31, 2010 at 9:46 pm

  #1111411

  forum member (1/31/2010)

  ---

  Hi There,

  insert into table(value1,value2)

  values ('123', select id from table where section='section 1')

  Try this instead.

  insert into table(value1,value2)

  SELECT '123', id from table where section='section 1'