INSERT INTO EQU.T_EQ_PERSONTEAM(EQ_PERSONTEAMID, FACTORYID,org_ID,PERSON_ID,TEAMID,POSTTYPE,POSTID,ISVALID,remark,LASTOPERATOR,LASTOPERATETIME)
(SELECT
lower(sys_guid()) EQ_PERSONTEAMID,
0 FACTORYID,
person.AREAID org_ID,
person.ID PERSON_ID,
0 TEAMID,
post.POSTTYPE POSTTYPE,
person.postid postid,
person.isused ISVALID,
'' remark
FROM pub.PERSON person
LEFT JOIN PUB.POST post ON person.POSTID=POST.ID
WHERE person.ID NOT IN (SELECT PERSON_ID FROM EQU.T_EQ_PERSONTEAM))
db2 sql批量插入一张表插入另一张表
最新推荐文章于 2022-10-24 14:47:53 发布