|
楼主 |
发表于 2020-4-2 15:03:35
|
显示全部楼层
select TALENT_PLAN.*,TALENT_FILLIN,TALENT_FILLIN.version as version,TALENT_FILLIN.DEPT as DEPT,TALENT_FILLIN.FINISHTIME as FINISHTIME,TALENT_FILLIN.IMPLEMENTATION_PLAN as IMPLEMENTATION_PLAN,TALENT_FILLIN.PROGRESS1 as PROGRESS1,TALENT_FILLIN.PROGRESS2 as PROGRESS2,TALENT_FILLIN.PROGRESS3 as PROGRESS3,TALENT_FILLIN.PROGRESS4 as PROGRESS4,TALENT_FILLIN.PROGRESS5 as PROGRESS5,TALENT_FILLIN.PROGRESS6 as PROGRESS6,TALENT_FILLIN.YEAR as YEAR
from TALENT_PLAN TALENT_PLAN
optional join TALENT_FILLIN TALENT_FILLIN on TALENT_PLAN.PCODE = TALENT_FILLIN.PCODE |
|