jdbc Adapter

when we select from One table And insert into Another table We want to Add one feld its possible

ie: we have a employe data like emp name, salary, disignation we select from one table And insert into Anoyher table we have to add “EMP ID” its possible how?