--把别的表的数据导到另外的表中
insert into kkk(myid,myname,mydeptno) select empno,ename,deptno from emp where deptno=10; insert into kkk(myid,myname,my
--把别的表的数据导到另外的表中
insert into kkk(myid,myname,mydeptno) select empno,ename,deptno from emp where deptno=10; insert into kkk(myid,myname,my