插入到表从另一个表和独立的价值

Question

说我有两个表，

Employee 
name address phone phone_type 

EmployeeContacts 
name address phone 

因此，我可以这样做：

INSERT INTO Employee name, address, phone VALUES(SELECT name, address, phone from EmployeeContacts where name = "Joe") and phoneType = "mobile" 

？

基本上，插入从一个表中选择的某些值并插入一个额外的值？

如果不是，我该怎么做？

Answer 1

您要使用的insert . . . select形式：

INSERT INTO Employee(name, address, phone, phonetype) 
    SELECT name, address, phone, 'mobile' 
    from EmployeeContacts 
    where name = 'Joe'