将内连接上的两列相乘
将内连接上的两列相乘
提问于 2017-07-07 05:28:12
需要帮助。
我想将两列相乘，并将结果显示到一个新列(TotalQty)。TotalQty= (ITY00.CMPITQTY * MPOS_GP_InvTransaction.Quantity)
我如何才能做到这一点？
Select
MPOS_GP_InvTransaction.id,
MPOS_GP_InvTransaction.[Type],
MPOS_GP_InvTransaction.Vendor,
MPOS_GP_InvTransaction.Currency,ITY00.CMPTITNM,
MPOS_GP_InvTransaction.BatchId,
MPOS_GP_InvTransaction.UserId,
MPOS_GP_InvTransaction.ItemNo,
MPOS_GP_InvTransaction.SiteId,
ITY00.CMPITQTY,
MPOS_GP_InvTransaction.Quantity,
MPOS_GP_InvTransaction.IntegrationFlag
From DB_37788.dbo.MPOS_GP_InvTransaction
INNER JOIN TWCL.dbo.ITY00 ON ITY00.ITEMNMBR=MPOS_GP_InvTransaction.ItemNo
Where (MPOS_GP_InvTransaction.ItemNo like '%-GTYR%' )
OR (MPOS_GP_InvTransaction.ItemNo like '%-JKOP%' )
And (MPOS_GP_InvTransaction.SiteId IN('MM-DC-ZZQW','MM-DC-TTYR') )
And (MPOS_GP_InvTransaction.IntegrationFlag = 0 )回答 1
Stack Overflow用户
回答已采纳
发布于 2017-07-07 05:30:25
SELECT MPOS_GP_InvTransaction.id,
MPOS_GP_InvTransaction.Type,
MPOS_GP_InvTransaction.Vendor,
MPOS_GP_InvTransaction.Currency,
ITY00.CMPTITNM,
MPOS_GP_InvTransaction.BatchId,
MPOS_GP_InvTransaction.UserId,
MPOS_GP_InvTransaction.ItemNo,
MPOS_GP_InvTransaction.SiteId,
ITY00.CMPITQTY,
MPOS_GP_InvTransaction.Quantity,
MPOS_GP_InvTransaction.IntegrationFlag,
ITY00.CMPITQTY * MPOS_GP_InvTransaction.Quantity AS TotalQty
FROM DB_37788.dbo.MPOS_GP_InvTransaction
INNER JOIN TWCL.dbo.ITY00 ON ITY00.ITEMNMBR = MPOS_GP_InvTransaction.ItemNo
WHERE(MPOS_GP_InvTransaction.ItemNo LIKE '%-GTYR%')
OR (MPOS_GP_InvTransaction.ItemNo LIKE '%-JKOP%')
AND (MPOS_GP_InvTransaction.SiteId IN('MM-DC-ZZQW', 'MM-DC-TTYR'))
AND (MPOS_GP_InvTransaction.IntegrationFlag = 0);页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/44959167
复制相关文章
相似问题
腾讯云开发者
