``` c.execute('insert into table_2 select max(id), ?, ?, ? from table_1', (item_name, item_code, cost_price)) ```