sql---临时表

建立临时表并插入数据

select sector_id, phycellid as pci into temp
    from tbcell
    where sector_id in
    (
        select distinct tbcell.sector_id
        from tbcell, tbcell38400
        where tbcell.ENODEBID = substring(tbcell38400.SECTOR_ID, 1, 6)
        union
        select sector_id
        from step1all_38400
    )

更新临时表

update temp
set temp.pci = Step1_result_38400.pci
from temp, Step1_result_38400
where temp.sector_id = Step1_result_38400.sector_id

删除临时表

drop table temp