如何在SQL中组合连接SQL查询和公式？ [英] How do I combine a join SQL query and formulas in my SQL?

问题描述

select StockReqTemp.SRT_ID,StockReqTemp.SRT_Descr,StockReqTemp.SRT_Qty,StockReqTemp.SRT_Unit,StockReqTemp.SRT_Conv,StockReqTemp.SRT_Price,(StockReqTemp.SRT_Qty * SRT_Price) as StockReqTemp.SRT_TAmt,StockReqTemp.SRT_ServedQty,ItemMasterlistTable.Item_Balance
from StockReqTemp
inner join ItemMasterlistTable
on StockReqTemp.SRT_ID = ItemMasterlistTable.Item_ID

我正在试图弄清楚如何插入乘法我的sql查询，因为我需要它。对我的查询进行修改的任何想法也许？



我尝试过：



我正在我的SQL服务器上进行试验和错误。当我删除公式时，它可以工作，但我无法获得SRT_TAmt（总金额）的值。

I'm trying to figure out how to insert a multiplication in my sql query since I need it. Any idea on a modification on my query perhaps?

What I have tried:

I'm doing a trial and error in a my sql server. When I remove the formula it works but I can't get a value for my SRT_TAmt(Total Amount).

推荐答案

您有语法错误

You have syntax error

SELECT 
    StockReqTemp.SRT_ID
  , StockReqTemp.SRT_Descr
  , StockReqTemp.SRT_Qty
  , StockReqTemp.SRT_Unit
  , StockReqTemp.SRT_Conv
  , StockReqTemp.SRT_Price
-- old code ( StockReqTemp.SRT_Qty * SRT_Price ) as StockReqTemp.SRT_TAmt
-- SRT_price belongs to StockReqTemp, i am guessing. may be you should mention that too as StockReqTemp.SRT_Price
  , ( StockReqTemp.SRT_Qty * SRT_Price ) AS SRT_TAmt
  , StockReqTemp.SRT_ServedQty
  , ItemMasterlistTable.Item_Balance
FROM StockReqTemp
INNER JOIN ItemMasterlistTable ON StockReqTemp.SRT_ID = ItemMasterlistTable.Item_ID

这篇关于如何在SQL中组合连接SQL查询和公式？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！