insert into A (operator,opername,corporationID) select 'cxm','陈总',corporationID from B where c_level='1';
谢谢!没错这样是可以: insert into A (operator,opername,corporationID) select 'cxm','陈总',corporationID from B where c_level='1'; 但我那operator和opername是不要B表中,只有corporationID才在B表中!那该怎么写呢?
你还可以这样写:insert into A (operator,opername,corporationID) select 'cxm','陈总',corporationID from B where c_level='1';
insert into A (operator,opername,corporationID) select 'cxm','陈总',corporationID from B where c_level='1';
但我那operator和opername是不要B表中,只有corporationID才在B表中!那该怎么写呢?