insert into schedule_3 (Serialnum,prjectname,projectcode,state,nodename,pedstate,unitcode)
values
(
select a.Serial,
c.apaname,c.apacode,2,a.ProjectNodename,1,b.unitcode
from Zdt_Model_ProjectPlan a , ZDT_PROJECTUNIT b , code_apanage c
where b.companycode=c.apacode
)
这是我执行的sql语句,看起来好像没什么问题啊,可就是执行不了,报错:缺失表达式各位路过的高手们,请帮帮忙吧
values
(
select a.Serial,
c.apaname,c.apacode,2,a.ProjectNodename,1,b.unitcode
from Zdt_Model_ProjectPlan a , ZDT_PROJECTUNIT b , code_apanage c
where b.companycode=c.apacode
)
这是我执行的sql语句,看起来好像没什么问题啊,可就是执行不了,报错:缺失表达式各位路过的高手们,请帮帮忙吧
insert into schedule_3 (Serialnum,prjectname,projectcode,state,nodename,pedstate,unitcode)
select a.Serial,
c.apaname,c.apacode,2,a.ProjectNodename,1,b.unitcode
from Zdt_Model_ProjectPlan a , ZDT_PROJECTUNIT b , code_apanage c
where b.companycode=c.apacode;
INSERT INTO TAB
SELECT * FROM SUB_TAB