How to select data and insert those data using single sql?

How to select data and insert those data using single sql?

pI want to select some data using simple sql and insert those data into
another table. Both table are same. Data types and column names all are
same. Simply those are temporary table of masters table. Using single sql
I want to insert those data into another table and in the where condition
I check E_ID=? checking part. My another problem is sometime there may be
any matching rows in the table. In that time is it may be out sql
exception? Another problem is it may be multiple matching rows. That means
one E_ID may have multiple rows. As a example in my attachment_master and
attachments_temp table has multiple rows for one single ID. How do I solve
those problems? I have another problem. My master table data can insert
temp table using following code. But I want to change only one column and
others are same data. Because I want to change temp table status column./p
precode insert into dates_temp_table SELECT * FROM master_dates_table
where e_id=?; /code/pre pIn here all data insert into my dates_temp_table.
But I want to add all column data and change only dates_temp_table status
column as Modified. How should I change this code?/p