嗯嗯,执行ksql:insert into sa_kc a (a.fid,a.fSL,a.version) (select b.fWPID,b.fSL,0 from sa_cgzbdetail b where b.fMasterID = :masterID)时出错! 找不到sa_kc的概念是什么意思啊
小楫夜泊1989 发表于 2015-4-1 21:09
嗯嗯,执行ksql:insert into sa_kc a (a.fid,a.fSL,a.version) (select b.fWPID,b.fSL,0 from sa_cgzbdet ...
insert into sa_kc a (a,a.fSL,a.version) (select b.fWPID,b.fSL,0 from sa_cgzbdetail b where b.fMasterID = :masterID) 改成这样吧,a就代表概念,映射数据库中的fID,这边是ksql,所以不需要a.fID