从另一个表中添加数据

例子1.

create table profession
(
    id int not null identity primary key,
    profession varchar(20)
)

insert into  profession (profession)
 select profession from my_contacts group by profession order by profession

转载于:https://blog.51cto.com/kaixinbuliao/881363