MySQL--根据审核时间排序，查询最后一次审核的物品采购记录

最新推荐文章于 2021-10-20 16:32:09 发布

beiguofengguang

最新推荐文章于 2021-10-20 16:32:09 发布

阅读量2.0k

点赞数

分类专栏： mysql 文章标签： null

本文链接：https://blog.csdn.net/beiguofengguang/article/details/7465537

版权

mysql 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

select *
from (select a.CheckDate, b.ProductID, b.Count, b.Price
          from tpurchase a, tpurchasedetail b
         where a.`Status` in (3, 4)
           and a.CheckDate is not null
           and a.PurchaseID = b.PurchaseID
         order by b.ProductID, a.CheckDate2 desc) m
where (select count(1)
          from (select a.CheckDate, b.ProductID, b.Count, b.Price
                  from tpurchase a, tpurchasedetail b
                 where a.`Status` in (3, 4)
                   and a.CheckDate is not null
                   and a.PurchaseID = b.PurchaseID
                 order by b.ProductID, a.CheckDate2 desc) s
         where m.ProductID = s.productid and m.CheckDate > s.CheckDate) < 1