INSERT INTO....SELECT

use AR_Enitor_Web_std_21

SELECT * FROM PubDoorGroupAuthDep

SELECT * FROM dbo.PubDoorGroup

SELECT * FROM dbo.PubDoorGroupList where doorGroupID = '00001'

select * from person where deptID='1231000'

SELECT * FROM PubDoorAuth

delete FROM PubDoorAuth

INSERT INTO PubDoorAuth(personID, doorID , weekTimeID , holidayGroupID , tag , reserve1 , reserve2 , reserve3 , reserve4 , modifyTime , operator

, UserGroupID , DoubleCheck , BlackList , Check_TimeZone , Check_Holiday , DownLoad_Fg )

SELECT person.personID,PubDoorGroupList.doorID,PubDoorGroupList.weekTimeID,PubDoorGroupList.holidayGroupID,pubdoor.productType,0 as reserve1, 0 as reserve2, null as reserve3,

'sync_auth_by_insert' as reserve4,getdate() as modifyTime, 'insert_batch' as operator, null as UserGroupID, PubDoorGroupList.DoubleCheck,PubDoorGroupList.BlackList,

PubDoorGroupList.Check_TimeZone,PubDoorGroupList.Check_Holiday,PubDoorGroupList.DownLoad_Fg

FROM PubDoorGroupAuthDep

left join PubDoorGroupList on PubDoorGroupAuthDep.doorGroupID = PubDoorGroupList.doorGroupID

left join PubDoor on PubDoorGroupList.doorID = PubDoor.doorID

left join person on PubDoorGroupAuthDep.deptID = person.deptID

where PubDoorGroupAuthDep.doorGroupID= '00001' and PubDoorGroupAuthDep.deptID='1231000'