There are ways of inserting data into table:
insert into MyTable (ColA, ColB, ColC) values ('A', 'B', 'C')
insert into MyTable (ColA, ColB, ColC) select colAA, colBB, colCC from MyTable2
Is there way to use insert into MyTable (ColA, ColB, ColC) select colAA, colBB, colCC from MyTable2
but instead of inserting for example colAA value into colA I woulkd like to insert there always 1.
THanks for help
See Question&Answers more detail:os