SELECT [vItemFlux2Save].[ItemID] AS [ItemID], [vItemFlux2Save].[NumMov] AS [NumMov], [vItemFlux2Save].[TotQta] AS [TotQta], [vItemFlux2Save].[TotQtaOrd] AS [TotQtaOrd], [vItemFlux2Save].[TotQtaCar] AS [TotQtaCar], [vItemFlux2Save].[TotValCar] AS [TotValCar] FROM [dbo].[vItemFlux2Save] AS [vItemFlux2Save] SELECT [vLocationVal].[LocationID] AS [LocationID], [vLocationVal].[TotVal] AS [TotVal], [vLocationVal].[NumArt] AS [NumArt], [vLocationVal].[TotCurr] AS [TotCurr], [vLocationVal].[TotPend] AS [TotPend] FROM [dbo].[vLocationVal] AS [vLocationVal]