insert query

[maravinds]

hi,

is it possible to have an insert query to fill some of the parameters by select query from other table and rest of the parameters by passing the value.


ex:
insert into table1(a,b,c) values (10,select b fom table2 where.... , 35);

i tried with the above syntax but was unable to succeed.

if this is not possible can anyone help me in solving the problem




thanks,

aravind

 

[Pat Hartman]

The easiest way to start is to create a select query that selects the data you want from tableB. Then change the query type to Append and choose the table to append to. Then if the field names are not identical, you will need to select the target column for each selected column.