如何从总库存中减去已售库存? [英] how to minus sold stock from total stock?

问题描述

我正在从事医院项目.我的问题是:我有两个表(1).库存和(2).详细信息.

Hii i am working on hospital project. My Issue is: i have two table (1). stock and (2). details.

库存表包含药品的总库存.

stock table contains total stock of medicines.

详细信息表包含总库存数量-售出的库存数量.

details table contains totalstockquantity - soldstock quantity.

我尝试过此代码:

$result=mysql_query(
"SELECT ((stock.quantity)-details.quantity) AS sub,
 stock.id AS id,
 stock.name AS name,
 stock.type AS type,
 stock.batch_no AS batch,
 stock.quantity AS quantity,
 stock.exp AS exp
 FROM stock
 INNER JOIN details on stock.name=details.medicine ");
?>

但是它会给出多个具有相同ID的结果.

but it gives multiple result of same id.

推荐答案

SELECT stock.quantity - (select sum(details.quantity) from details where stock.name=details.medicine) AS sub,
 stock.id AS id,
 stock.name AS name,
 stock.type AS type,
 stock.batch_no AS batch,
 stock.quantity AS quantity,
 stock.exp AS exp
 FROM stock

这篇关于如何从总库存中减去已售库存?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！