查询剩余股票 [英] Query for Remaining Stocks

问题描述

嗨先生，



如何为产品剩余库存创建查询？



这是我的桌面设计：



DeliveryDetails

Del_detID

DeliveryID

ProdID

DeliveryPrice

DeliveryQty



产品

ProdID

名称

描述

ReOrderLevel



订单详情

Order_detID

订单ID

产品

OrderPrice

OrderQty

Hi Sir,

How to create a query for remaining stocks of a product?

Here is my table design:

DeliveryDetails
Del_detID
DeliveryID
ProdID
DeliveryPrice
DeliveryQty

Product
ProdID
Name
Description
ReOrderLevel

OrderDetails
Order_detID
OrderID
ProdID
OrderPrice
OrderQty

推荐答案

从我所看到的，你不能。



那里在那里没有明显的栏目来保持库存水平，没有它就无法估计你开始的数量，更不用说你剩下多少了！

From what I can see, you can''t.

There is no obvious column in there to hold the stock level, without which you cannot estimate how many you had to start with, much less how many you have left!

只写2个查询

从DeliveryDetails中选择Sum（DeliveryQty），其中ProdID = 1

从OrderDe中选择Sum（OrderQty）尾巴，其中ProdID = 1



这2个查询返回2个值，所以现在简单的数学

StockRemaining = OrderQty - DeliveryQty

Just Write 2 Queries
"Select Sum(DeliveryQty) From DeliveryDetails Where ProdID = 1"
"Select Sum(OrderQty) From OrderDetails Where ProdID = 1"

These 2 queries return 2 Values so now simple maths
StockRemaining = OrderQty - DeliveryQty

这篇关于查询剩余股票的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！