select DimReseller.ResellerName,FactResellerSales.*,DimProduct.ProductAlternateKey into glfxb from DimReseller,FactResellerSales,DimProduct
where(DimReseller.ResellerKey=FactResellerSales.Resellerkey and DimProduct.ProductKey=FactResellerSales.ProductKey)
INTO [新表名]
FROM [旧表名] where(关联字段)