查询数据插入到临时表

示例代码    select  A.[ID] as [itemid], A.[Code] as [itemcode], A2.[ID] as [warehouseID], 
    A2.[Code] as [warehouseCode], A3.[Name] as [warehouseName]
    into #tmpItemmaster
     from  CBO_ItemMaster as A  
    left join [CBO_InventoryInfo] as A1 on (A.[InventoryInfo] = A1.[ID])  
    left join [CBO_Wh] as A2 on (A1.[Warehouse] = A2.[ID])  
    left join [CBO_Wh_Trl] as A3 on (A3.SysMlFlag = 'zh-CN') and (A2.[ID] = A3.[ID])
	where A.Org = @currentOrg