INSERT into a table records extracted from another table

How to INSERT into a table records extracted from another table?

If you want to insert values from one table into another you can use this sql query.

insert into TBL_TARGET([USERNAME],[PASSWORD],[ACTION])

 

select [USERNAME] ,[PASSWORD], 'I'

 

from [TBL_SOURCE]