关于表自身的复制

Question

不知这样行不行，没试过，楼主可以试一试:
INSERT ALL
     INTO BIL_WORKTEMPLET (TEMPID,TEMPTYPE,WORKTYPE,TASK,GZTJ,AQCS1,AQCS2) 
         Valuse (a.TEMPID,a.TEMPTYPE,a.WORKTYPE,a.TASK,a.GZTJ,a.AQCS1,a.AQCS2)
     INTO BIL_WORKTEMP7CONT (a.TEMPID,b.CONTID,b.STEP,b.ITEM )
   SELECT  a.TEMPID,a.TEMPTYPE,a.WORKTYPE,a.TASK,a.GZTJ,a.AQCS1,a.AQCS2,
           b.CONTID,b.STEP,b.ITEM 
     FROM BIL_WORKTEMPLET a join BIL_WORKTEMP7CONT b on a.TEMPID=b.TEMPID
    WHERE a.TEMPID = 'guid'