Hi,
I would like to insert into a table values from a table and user defined
ones. Here is the example:
I found this statement to insert values from another table:
INSERT INTO test_table (cust_id, cust_name) SELECT id, name from CUSTOMER;
But the test_table has another column, which should have the same value
for all the customers.
Is there something like
INSERT INTO test_table (int_id, cust_id, cust_name) '1', SELECT id, name
from CUSTOMER:
and if so, what ist the correct statement? If not, what is an
alternative to insert a single row at a time?
Thanks in advance
Silke