Select 'POSINV' As DocTypeCode, h.InvoiceStatus As DocStatus, h.InvoiceNo As DocNo, h.MaskedInvoiceNo As ReferNo, h.InvoiceDate As TxDate, h.MarkDel HeaderMarkDel
, h.Shopcode As ReferShopCode, h.ShopCode As ActionShopCode, h.ShopMachineCode As MachineCode, d.PLU, d.QtySold As OrgQty, d.QtySold As FinialQty, -1 As Direction, d.MarkDel DetailMarkDel
From tblInvoiceH h Join tblInvoiceD d on h.ShopCode = d.ShopCode And h.InvoiceNo = d.InvoiceNo And h.SysID = d.InvoiceHSysID
UNION ALL
Select 'PO' DocTypeCode, poh.POStatus As DocStatus, poh.PoNo As DocNo, '' As ReferNo, poh.PORecDate As TxDate, poh.MarkDel HeaderMarkDel
, poh.OrderShopCode As ReferShopCode, pod.DlvyShopCode ActionShopCode, poh.MachineCode, pod.PLU, pod.SupplierQty As OrgQty, pod.RecSupplierQty As FinialQty, 1 As Direction, pod.MarkDel DetailMarkDel
From tblPOHeader poh Join tblPODetails pod on poh.OrderShopCode = pod.OrderShopCode And poh.PONO = p
库存查询SQL语句,用到的相关技术
最新推荐文章于 2024-06-19 10:59:12 发布
这篇博客展示了如何使用SQL进行库存查询,包括POSINV、PO和库存移动记录的联合查询。通过示例,解释了如何利用常规查询、左连接和联合查询组合条件,简化SQL语句,提高查询效率。
摘要由CSDN通过智能技术生成