问创建一个表，其中包含具有来自另一个表的值的属性

EN

create table medics (
    medic_id int identity(1, 1) primary key,
    payment ?,  -- whatever the type is
    specialty nvarchar(255),
    person_id int,
    foreign key (person_id) references persons(person_id)
);

create tabel persons (
    person_id int identity(1, 1) primary key,
    name nvarchar(255),  -- or whatever
    . . .   -- and so on
);

insert into medics (payment, specialty, person_id)
    select @payment, @specialty, p.person_id
    from persons p
    where p.name = @name;