sql insert into table from another table

postgresql insert into table from another table

mysql insert into table from another table

sql insert into table from another table with constraint